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

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.