Forum Discussion
Grouping table rows based on values
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
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 document to do that.
Note : I have two separate table for County and City.
From :
Country | City |
USA | New York |
USA | Boston |
USA | Atlanta |
UK | London |
UK | Manchester |
UK | Birmingham |
UK | Liverpool |
To :
Country | City | Place | Open Hours |
USA | New York | Central Park | 10 AM |
|
| Times Square | 9 AM |
|
| High Line | 11 AM |
| Boston | Fenway Park | 10 AM |
|
| XXX | 1 |
|
| XXX | 2 |
| Atlanta | YYYY | 3 |
UK | London | A | 1 |
|
| B | 2 |
| Manchester | A | 1 |
|
| B | 2 |
|
| C | 3 |
Did this resolve your issue?