Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn 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?
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 53 | |
| 45 | |
| 38 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 82 | |
| 69 | |
| 39 | |
| 29 | |
| 27 |