Forum Discussion
Merge Cells in Matrix Visualization Not Working
Hello! I tried to follow the directions in the following post to merge cells in Power BI, but I am stuck b/c the "expand hierarchy" button does not appear on my matrix: https://community.powerbi.com/t5/Desktop/Merge-cells-in-tabular-visualization/m-p/738630
I currently only see these buttons to toggle on my matrix:
I am looking to merge the rows that appear below in the visualization portion of my dashboard.
Country | City | Year | Sales | Target Reached |
IND | Hyd | 2016 | 500000 | Yes |
IND | Hyd | 2017 | 400000 | No |
IND | Hyd | 2018 | 70000 | Yes |
IND | Blore | 2017 | 550000 | Yes |
IND | Blore | 2018 | 650000 | Yes |
US | AZ | 2018 | 700000 | Yes |
US | AZ | 2017 | 400000 | No |
US | AK | 2017 | 5000000 | Yes |
US | AK | 2018 | 34000 | No |
Output
Look at the Rows section in the picture of the post you linked above
5 Replies
I got it working now! Thank you!
StefArroyo Glad that you have solved this problem, you may accept the appropriate reply as the solution to close this topic thus others will find the solution quickly. Thanks a lot.
Best Regards,
Community Support Team _ Jing Zhang
Have you got more than one field in the rows section?
No, I just have 1 field in the rows section.
Look at the Rows section in the picture of the post you linked above
