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,...
Need Help
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