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

[jpchen]

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.

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.

[v-luwang-msft]

Hi @jpchen ,

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

Best Regards

Lucien

[jpchen]

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.

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