Group rows without measure

[volekss]

How can I group rows in table or other visual if they doesn't contain measure and I can't use agregation?

I would like to transform following data table to following report:

[v-huizhn-msft · Accepted solution]

Hi @volekss,

I reproduce your scenario and get expected result.

1. Create sample table as follows.



2. Create a matrix, turn off the "Stepped layout" button, select all fields as rows level, expand the matrix, you will get expected result.

     

Best Regards,
Angelia

[volekss]

Hi @v-huizhn-msft!

Thank's a lot!

Works like a charm!