Sync two different slicers from different tables without a relationship in Power BI

Synchronize two different slicers (a visual control element that allows users to filter data) from different tables in Power BI, despite there being no direct relationship between those tables.

This means that the user wants to filter data in one slicer based on the selections made in another slicer, even if the two slicers are connected to different data sources or tables within Power BI.
#powerbi #powerplatform

[rupito]

Genious! I spent hours looking how to do it and your solution was gold.

[MarkHinderliter]

Genius! Pure genius! Thank you for saving me from having to write a heap of spackle code in SQL to make up for the lack of interaction between tables.

[coryg]

Excellent work. Very quick and easy to do. Thank you very much!!!

[vijayaitha]

Recently I faced same issues but after seeing this video I get more clarity on my issue .
Thankyou bro

[cafdo]

This is the best way, especially if you are having unexpected results due to relationships and cardinality. Thanks you for this. Simple is always better.

[R-ejgt]

This is absolutely genius!! Worked perfectly! Thank you for posting this video!

[SanatanSekkers]

Thnx a lot for the helpful video, it worked well but I have a question, when we add countries to the slicer the drop-down doesn't change it shows the whole value not the value for individual countries.

[lubo]

I would like to express my gratitude for your help and support. Thank you very much.

[gerrieolivier]

Thank you. This is a great work around for indirect relationship issues

[yohansean]

This worked for me. But I had an issue to get this to work for grouped field. I have created the same grouped field on both the datasets and everything is same intterms of the name of the grouped field as well as the groups but it just does not sync.
Any thoughts on this? I would really appreciate if you have any tips on this.

[ganeshn]

What to do if few entries are unique and not present in 2 nd table and vice versa. Is there any way? Ex, addition to these 3 region, we have south America in 1 table and asia in 2 nd table. Can we combine both to compare the data of both the table? Creating single table can work but doing analysis of 2 tables via graph

[vedikachoudhury]

Is there a way to do this accross multiple pages? When I tried, it worked for only the page the filter is on, despite using sync slicer.

[Manu-lirw]

this also works for multiple tabs in pwoer bi? i am having issues when applying this to multiple tabs

[preetamdevadiga]

This even works for Date Slicers! Thank you sir

[WYFBYL]

OMG I've been struggling whole morning, thank you!

[indukrishna]

worked perfectly at the most crucial time for me. thanks alot sir.

[boondikeladoo]

This was such a great, clear, and simply explained tutorial. Thank you!

[JillCox-pn]

This was so helpful and saved me a ton of time. Thank you!

[TheDistractionStudio]

THANK YOU + THANK YOU MORE and then some more. SAVED my headache in minutes.

[kalyanigopakumar]

This saved my life! Thank you for giving this solution and saving a lot of my time!