Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
samnaw
Resolver I
Resolver I

Filters not syncing between tabs

Hello:

 

I am not able to sync my filters:

 

I have two tabs in my report. Left hand side report and right hand side report. 

 

I have managed to sync all filters except the one on the top (yellow highlight). Its doesnt let me make this relationship active. 

 

Its says "To make this relationship active, deactive or delete one of the relationship between [Top Table] and [Bottom Table]"

 

[Top Table] is the one on the very top. It says storeName

[Bottom Table] is one below the middle table. Its says "SYW"

 

When I filter "storeName" the table on the right hand side doesnt filter. I think its becuase its not an active relationship. 

 
 

filters.PNG

 

2 ACCEPTED SOLUTIONS
JosefPrakljacic
Solution Sage
Solution Sage

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

View-my-LinkedIn-profile-image-3-300x140.png.png

View solution in original post

v-rzhou-msft
Community Support
Community Support

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.

1.png

Top:

1.png

Bottom:

2.png

Right:

3.png

Left:

4.png

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.

5.png

If you want to sync the filter in Top to left table, you may try to build a relationship as below.

6.png

Then result is correct.

7.png

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. 

View solution in original post

3 REPLIES 3
v-rzhou-msft
Community Support
Community Support

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

v-rzhou-msft
Community Support
Community Support

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.

1.png

Top:

1.png

Bottom:

2.png

Right:

3.png

Left:

4.png

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.

5.png

If you want to sync the filter in Top to left table, you may try to build a relationship as below.

6.png

Then result is correct.

7.png

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. 

JosefPrakljacic
Solution Sage
Solution Sage

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

View-my-LinkedIn-profile-image-3-300x140.png.png

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.