PBI Desktop - Slicer option and dynamic levels in Matrix

[Anonymous]

Hello gurus,

I have a requirement.  Have a matrix report that shows the Industry/subindustry with measures.  The requirement is I need to  given an option in the slicer "Industry/SubIndustry"(2 levels)  Or LOB(3 Levels).  The Industry/SubIndustry is at a two-level hierarchy and the LOB is a three level hierarychy.  The columns are available in the base table.  How do I go about this? I need to have this dynamically in the same page, not additional page for LOB (something, like the Hierarchy changes dynamically). 

Thanks in advance!

Here's the sample: 

If IndustrySubIndustry option is chosen, the below should appear: 

Industry & Sub Industry	Measure1	Measure2	Measure3
Transportation	100	50	40
Air	70	30	20
Other	30	20	20
Agriculture	200	100	100
Livestock	100	40	40
Fruits	100	60	60

If LOB is chosen, following should appear:

LOB - Lvl, Lvl2, Lvl3	Measure1	Measure2	Measure3
Capital Markets	100	100	100
International
Americas	50	100	100
Trading Products
TP Fund	50	50	50

[jdbuchanan71]

@Anonymous 

You could use bookmarks to change the columns that are displayed in your matrix then just add 2 buttons, and link each bookmark to 1 of the buttons so the users can swtich.  Take a look at this video introducing bookmarks and buttons.

https://www.youtube.com/watch?v=_Afcj8mT5_Q&ab_channel=GuyinaCube