Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
Solved! Go to Solution.
Look at the Rows section in the picture of the post you linked above
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
No, I just have 1 field in the rows section.
Look at the Rows section in the picture of the post you linked above
Have you got more than one field in the rows section?
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 29 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 73 | |
| 63 | |
| 44 | |
| 23 | |
| 22 |