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:

  • 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

2 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    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