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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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