Forum Discussion

BimalSubhasis's avatar
BimalSubhasis
Icon for Advocate III rankAdvocate III
3 years ago

Dynamically change matrix rows based on slicer selection

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.  Examp...
Need Help
Tutorial Requests
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
3 years ago

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