Forum Discussion
volekss
8 years agoFrequent Visitor
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:
- 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
8 years agoMicrosoft 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
- volekss8 years agoFrequent Visitor