Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi
I am trying to sync slicers from two data tables both consisting of month and Year in the same format linked on month name. But I would like one slicer to sync to the other slicer for the table visuals.
Been trying things that are messy and would not be able to even explain what I have done. But essentially I had two slicers (slicer1, Slicer2)each pulling in the year and month from the two different data tables. Page one has slicer1 and filters Table1 visual. Page two has Slicer2 and Table2 visual but I want Slicer1 to filter Slicer2... hope that makes sense.
Not sure if I am not doing it right. Any help would be appreciated.
Solved! Go to Solution.
Hello @Rejaul84 ,
you should have a seperate table that is dim date table that you make a relationship between the two tables with it on the date field.
then use the year and month slicer from this new dim date table and enable the sync between both slicer, this would work for your case.
check this out for the dim date table
https://youtu.be/-jRNjXyyWI4?si=KmZIy3vWnsbLqhwV
Proud to be a Super User! | |
Hello @Rejaul84 ,
you should have a seperate table that is dim date table that you make a relationship between the two tables with it on the date field.
then use the year and month slicer from this new dim date table and enable the sync between both slicer, this would work for your case.
check this out for the dim date table
https://youtu.be/-jRNjXyyWI4?si=KmZIy3vWnsbLqhwV
Proud to be a Super User! | |