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 in Power BI without creating numerous calculated tables and DAX expressions?
14 Replies
Hi Anonymous ,
Not very clear, but I understand you want to filter values in another filter based on the selection.
Se this video.
https://www.youtube.com/watch?v=cyOquvfhzNM
One Slicer to filter other slicers based on Items that has value only in Power BI without BI Directi
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)- Pragati11
Super User
Hi Anonymous ,
Can you share some screesnhots around what you are using and trying to achieve?
Always add details to your query for others to understand in a better way.
Thanks,
Pragati
- Pragati11
Hi Anonymous ,
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
- AllisonKennedy
Community Champion
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.
- amitchandak
Anonymous , not very clear. But I think this can help
