Dynamically change matrix rows based on slicer selection

[BimalSubhasis]

Hi All, I Need quick help on matrix and slicer selection. 

The request is like this: The client wants to select 3 slicers based on priority and accordingly, the matrix rows should change. 

Example: Let's say there is 3 different slicers  - City, State & Country.

Suppose the client selected the first slicer as Country, Slicer2 as State, and slicer3 as City then the ROWS in the matrix visuals should go update in the same sequence.

Client2 selected - Slicer1 as City, Slicer2 as Country & Slicer3 as State then the ROWS should amend accordingly from the above selection Country, State & City to City, Country & State. 

Please help me to achieve this. 

@Greg_Deckler @PaulDBrown @amitchandak @EnterpriseDNA @parry2k @jdbuchanan71 @dkay84_PowerBI @Helper @BIHelper @powerbihelp 

[BIHelper]

@BimalSubhasis can u please explain your problem with adding some screenshots so that we can get an idea.

[PaulDBrown]

I'm not too sure what you wish to achieve exactly. City is a subset of state which is a subset of country. So if you select a city as your first option, the rest of the selections should be within the actual possible options. In other words if you select London as the first selection in the slicer, you should be limited to the UK states and UK as a country, right? If this is what you need, then...

With this model (note the one-to-many single direction relationships between the slicer tables and the fact table):

Create the follwoing measure to add to the filter pane of each slicer, setting the value to greater or equal to 1:

Filter Slicers = 
COUNTROWS(RELATEDTABLE('Territories Table'))

and you will get

Sample PBIX attached