Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create a table summarised by a by a column

Morning,

 

I have a table in Power BI which shows number of days outside SLA, and the associate IDs that go with each case. 

At the moment, my table shows every single case individually. In excel, the pivot function allows you to summarise the number of days into groups, so the user can expand and then see the associated IDs. 

 

Because [No. days outside SLA] is a calculated field, I can't seem to create a heirarchy, and also I am on the November release of Power BI without much table/matrix functionality. 

 

Is there any way I can replicate the Pivot in Power BI?

Need Help

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    You can use a Matrix to display a similar output.

     

    Turn off "Step layout" and turn on "+/- icons" under "Row Headers" pane.

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks Yuliana, v-yulgu-msft

       

      Attached screenshot is what I get when I apply the same rules as you. Could it be that I am using the November release of Power BI and you are using the most up-to-date? Or am I missing something?

       

      Jemma :robotindifferent:

       

       

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi Anonymous,

         

        Make sure you have turned on "+/- icons" under "Row headers". If there is no such an option in your desktop, please update it to the latest version.

         

        Best regards,

        Yuliana Gu