Slicer filtering another Slicer from seperate tables.

[Rejaul84]

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.

[Idrissshatila · Accepted 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