Forum Discussion
Relevant Data in Filters
I would like to limit the options in filters as values are selected in other filters. This was easy in Tableau, I just click "Only Relevant Values" in the filter settings. Is there a way to do this...
Hi ghutchins ,
If your interations are enabled in Power BI, then this happens by default.
Suppose you have 3 filters on your report --> When you select a value in 1st filter, other 2 filters have values relevant to the selection made in the 1st filter.
Consider following example where I have 2 filters:
Now when I select a value in 1st filter, the 2nd filter shows relevant values:
To check if interactions are enabled for filters, go to folloiwng path as shown below:
Thanks,
Pragati
- As Pragati11 mentioned, this will happen automatically only if the cross filter direction allows it to.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#:~:text=Single%20cross%20filter%20direction%20means,side%20(bi%2Ddirectional).
I do NOT recommend changing your cross filter direction just to make this work, so...
The video link provided by Anonymous is a good workaround /hack for making one slicer filter another, but will require a bit of manual filter setup in the first instance.
