The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 !
Solved! Go to Solution.
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.
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.
Hi @Ella123
The relationship between these two table i.e. document1 and training 1 are inactive. You need to create a active relationship between these tables then only the slicer will be effective, try to create a active relationship under the edit relationship.
Thanks!
The relationship between 'Document (1) 3' and Training1 is not active. You need to make it active.