locked
pivot on ssrs or power bi? RRS feed

  • Question

  • Hi expert,

    I need to build a report in ssrs or powerbi like the below:

    Of course, I have the data in a table like:

    Complete date

    2018-05-03     2

    2018-05-04      2

    I there any way of doing it in ssrs or powerbi, or do I need to group by, (and somehow return each monthas column) in the code in sql?

    Wednesday, May 16, 2018 5:47 PM

All replies

  • Yes

    You can do this in both ssrs and in power bu

    In SSRS you would need a matrix container with column group with expression as below

    =Month(Fields!CompleteDate.Value)
    and based on what you've on top (its not visible in screenshot) you need to have parent column group on the required column

    then in data area add expression for your value like

    =Sum(Fields!ColumnName.Value)

    i hope its the sum you want

    similary add a total column for the column group and then add expression for rate


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Proposed as answer by Mitarai Queen Thursday, May 17, 2018 2:55 AM
    Wednesday, May 16, 2018 6:05 PM