Forum Discussion
Slicer not affecting any visuals
Ah I see. Yeah everything is bi-directional, so I don't think that's an issue. I suspect PBI has an interesting behaviour where visuals can't be filtered through indirect relationships.
I'm now just including the columns I'm filtering by in the central table that all the other tables are related to. I'm trying to make a slicer that includes all these columns, but there doesn't seem to be a way to do that without them nesting. I tried making a field parameter slicer but it has no effect, and when I put a filter on this slicer to only select "Yes" values in the relevant columns, it still has no effect.
How do I create a slicer that filters by values form multiple columns?
i.e. a slicer containing multiple seperate categories.
Community SupportHi, Anonymous
Acoording to your description , you wan to create a slicer that filters by values form multiple columns.
I have no sample test data and i do not know what the relationships in your model .
For your need , if you need to create a slicer to filter multiple columns in your visual , you can try to create a measure to return a value to control the row if you need to show in the visual.
And then you can put this measure on the "Filter on this visual" and then you can filter the visual by your custom slicer.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This would not work as I would need to do it for every single visual.
It looks like you can download slicers that can filter by multiple categories in a non-nested way - but I haven't found one that also *looks nice* lol.Can't win.