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