Forum Discussion
Slicer not affecting any visuals
(1) The relationships are definitely set up correctly, from what I can tell. All tables are unpivoted and link back to the central table via UUID (many to one, both ways). What DOES work is if the columns I want to filter my tables by are simply included in the central table, rather than having the filter columns as their own seperate table. From this I can conclude that a feature (bug?) of Power BI is that it can't filter tables through indirect relationships. Now my goal is to look into a way of getting the slicer properties that I want, with the filter columns included in the central table.
(2) Shouldn't visuals be able to be filtered by multiple filters and slicers? I can confirm this works for me.
(3) and (4) I'm not entirely sure what you mean/why?
I appreciate it's difficult to really diagnose this without providing a file. When I get time I will try to supply one.
Hi , Anonymous
Thanks for your quick response , for the (3) and (4) , i mean that if you have a one-to-many relationship , and the it is not a Bi-directional relationship , the filter will just from one to many . If you put the fields on the fact table , it will not filter the other fact table util it have the Bi-directional.
You can understand that relationships are all from one-side table to multi-side table by default, and can be passed.
If it is a one-way relationship, some tables cannot be filtered after the relationship is broken.
And for relationships, we recommend using one-to-many relationships.
For more information, you can refer to :
Bi-directional relationship guidance - Power BI | Microsoft Learn
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
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.
Hi, 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.