Forum Discussion
ghutchins
Helper II
Helper IIRelevant 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...
ghutchinsHelper II
Helper IIAllisonKennedy I verified again that any choice in AreaName has no effect on LevelName. I will try to use slicers but my customers demands leave very little room for a slicer. I have no room for a slicer and I know it is not best practice to overfill a canvas with visuals, but i am taking baby steps in that direction.
AllisonKennedy
Community Champion
Community ChampionThanks for the update ghutchins
This behaviour is due to the cross-filter direction being set to single - so a filter from one dimension table will not filter a filter from another dimension table with that setting.
All options I can think of are all less than ideal, but rarely do we have ideal data scenarios, so:
Option A - Use slicers and the custom measure workaround for filtering slicers in dimension tables: https://www.youtube.com/watch?v=cyOquvfhzNM
Option B - Change the cross-filter direction to 'both' for those tables
Option C - Merge all data into one table
Like I said, I try to avoid doing Options B and C as a general rule, so hesitate to even suggest them here, but they would help you get the result you are asking for.
Otherwise, you can always try and use drillthrough maybe to free up some space on the page if it doesn't all need to be viewed at once?
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
This behaviour is due to the cross-filter direction being set to single - so a filter from one dimension table will not filter a filter from another dimension table with that setting.
All options I can think of are all less than ideal, but rarely do we have ideal data scenarios, so:
Option A - Use slicers and the custom measure workaround for filtering slicers in dimension tables: https://www.youtube.com/watch?v=cyOquvfhzNM
Option B - Change the cross-filter direction to 'both' for those tables
Option C - Merge all data into one table
Like I said, I try to avoid doing Options B and C as a general rule, so hesitate to even suggest them here, but they would help you get the result you are asking for.
Otherwise, you can always try and use drillthrough maybe to free up some space on the page if it doesn't all need to be viewed at once?
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough