cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jpchen
Frequent Visitor

Values in matrix show the next level in the hierarchy when selecting from slicers?

Hi, I have been searched for a quick solution for the past two days but couldn't find any. Pls help.

 

I would like to change my Matrix visual when selecting from Slicer. The Slicer has hierarchy in it.

First level - Division, second level - Entity, third level - Center, last level - Department.

 

For example, when I select one Division (HBKU excl. RIs) from the Slicer, I would like to see Entity of HBKU excl. RIs. in Matrix by default. For the right chart, I'd like to see Entity of HBKU excl. RIs. by default.

 

Capture_210914_01.PNG

 

After selecting Division (HBKU excl. RIs) from the Slicer, I select one entity from the Division (HBKU ACADEMIC), I would like to see Centers of the Entity (HBKU ACADEMIC) in Matrix by default. For the right chart, I'd like to see Centers of HBKU ACADEMIC by default.

 

Capture_210914_02.PNG

 
2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @jpchen ,

Could you pls share your pbix file ,and remember to remove confidential data.

 

Best Regards

Lucien

Hi @v-luwang-msft ,

 

Please see my pbix file Test pbix (Choose "Free Download" on the left). Thanks for the kind assistance.

 

The Slicer has hierarchy - starting from Div. at the top followed by Entity and then by Center.

 

Ideally, I would like to see the next level in the Matrix when I select the Slicer. For example, when I select "Corporate" from Div., I'd like to see ARCHIVE OFFICE, BMO, ... shown in the Matrix by default.

 

Capture_210920_00.PNG

When I select "CHAIRPERSON'S OFFICE" from Entity, I'd like to see Chairperson, Chairperson Assistant shown in the Matrix by default.

Capture_210920_01.PNG

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!