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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Rejaul84
Frequent Visitor

Slicer filtering another Slicer from seperate tables.

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.

1 ACCEPTED SOLUTION
Idrissshatila
Super User
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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

1 REPLY 1
Idrissshatila
Super User
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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors