Forum Discussion
Visual level filtering for slicers
There is a hack for this ...
1. turn the visual into a bar chart
2. apply the visual level filter
3. turn the visual back into a slicer
You can add a page level filter and remove what you don't want to appear in the slicer. This is really useful when your requirment is to remove (Blank) or empty option from the slicer.
If a direct page filter wont' help, then you are probably filtering the wrong table and a relationship is missing.
Anoterh way to help limit your slicer options is to ensure you have cross filtering enabled.
often you have filters on the page, but the slicers seem unaffected by the filters. that's possibly because you're filtering for all won opportunities but are not applying that filter back to the accounts list. (just as a concrete excample I was struggling with)
if you configure your relationship between the two tables to not just filter in a single direction but both you will see that slicers automatically filter too.
PS. this cross filter option often only works once. PowerBI does not like multiple cross filters in your model as it can only handle a singe filtering path.
This was 100% what I was running into with trying to filter down my results in a table. Thanks a lot for the info! Works perfectly