Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
StefArroyo
Microsoft Employee
Microsoft Employee

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:

StefArroyo_1-1605724797616.png

 

 

 

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

1 ACCEPTED SOLUTION

Look at the Rows section in the picture of the post you linked above

View solution in original post

5 REPLIES 5
StefArroyo
Microsoft Employee
Microsoft Employee

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

StefArroyo
Microsoft Employee
Microsoft Employee

No, I just have 1 field in the rows section.

Look at the Rows section in the picture of the post you linked above

HotChilli
Community Champion
Community Champion

Have you got more than one field in the rows section?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.