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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
StefArroyo
Employee
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
Employee
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
Employee
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
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.