Forum Discussion
Slicer doesn't filter a table visual
Dear All,
Like the titel says the slicer doesn't filter a table visual.To describe the issue, i have two (document1(3) and training1) tables that both have 'Name' column with the same names and i have connected them in model view (so 1-1 cardinality). I used the slicer from the table 'document(1) 3' to create the name slicer which should filter the table visual ( created from table 'training1') but for some reason like i said the slicer doesn't filter the table . I have another table visual created from the same table of the slicer visual (document(1)) which does filter the names in this case.I don't undersand where the issue is . As I'm using confidential data , i can't share the tables but here is the model view :
Any help is appreciated !
- Anonymous1 year ago
Hi, Ella123
The active relationship should be solid. You set the relationship between the tables to active and then see if the tables filter properly.
Active vs inactive relationship guidance - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- johnt75Super User
The relationship between 'Document (1) 3' and Training1 is not active. You need to make it active.
- AnonymousNot applicable
Hi, Ella123
The active relationship should be solid. You set the relationship between the tables to active and then see if the tables filter properly.
Active vs inactive relationship guidance - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.