Forum Discussion
vishnukumar
8 years agoAdvocate I
Grouping table rows based on values
Hi, I am new to PowerBI Desktop. I would like to group rows based on column values. Here I have given below example what I am trying to achieve. Can some one share me the step by step guiding doc...
- 8 years ago
Hi,
My problem resolved by using matrix and below tips.
"Once you have your values set in the row section of your matrix, go to your visualization. In the upper left, click the drilldown "Expand all down one level in the hierarchy" it is the right-side selection that forks. Click that until you get to the bottom level of what you want to see. Then go to the formatting option for the matrix, under "Row Headers" turn "Stepped layout" off.
That should list your matrix in a table style look while not repeating the valuse of the left side columns. "
Regards,
Vishnu
Phil_Seamark
8 years agoMicrosoft Employee
- vishnukumar8 years agoAdvocate I
Hi,
sorry for the delay. All fields like (Country, City, Place, Openhours) in a seperate tables.
Regards,
Vishnu