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:
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-msftMicrosoft 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- volekssFrequent Visitor