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 |
Use the Matrix visualisation (it's in between the table and R script visuals).
Hi Phil_Seamark,
Thanks for you suggestion. Database re-creation is going on, I will try with matrix and let you know soon.
Mean while, is there any sample, then please share.
Regards,
Vishnu
Hi,
When I am trying with Matrix, I canot see any rows are binding.
its only displaying country as first column and City is displaying as column header.
Country Newyork Boston USA May I know exact step I need to follow or can you refer any video.
Regards,
Vishnu
Hi,
Can some one guide me to do the Matrix Row Grouping ?
Regards,
Vishnu
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