Forum Discussion

volekss's avatar
volekss
Frequent Visitor
8 years ago
Solved

Group rows without measure

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's avatar
    v-huizhn-msft
    8 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
    volekss
    Frequent Visitor
    8 years ago

    Hi v-huizhn-msft!

     

    Thank's a lot!

    Works like a charm!