Forum Discussion
Filters not syncing between tabs
Hello,
the problem you have is not with the Sync Slicer functionality but with your data model.
You have circular dependencies here and will have a lot of problems with this data model.
Please make sure you watch this valuable video
and get rid of these many bidirectional relationships.Here is a good explanation how to model your data.
Please don't forget to give a 👍 and accept the post as solution. (If it helped 😅)
Have a nice day!
BR,
Josef
Graz - Austria
Hi samnaw
Your problem may be that when you filter StoreName in Top Table, your left table show the wrong result due to inactive filter.
I build a sample to have a test.
Top:
Bottom:
Right:
Left:
Ex: If I select A in Store Name in Top.
Due to A in Right has SYW = x ,y, left table will be filtered by SYW. So it returns to A,B,C which has SYW =x/y it is in correct.
If you want to sync the filter in Top to left table, you may try to build a relationship as below.
Then result is correct.
Or you can delete relationships between all tables.
And build measure to achieve your goal.
You may refer to this blog: Filter table by measure
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi samnaw
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou