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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
tomas12344
Helper III
Helper III

Sync slicers of different type and content

HI All

I have a calendar table, where I have 2 columns for month: month number and mont name. I need to use these 2 columns for slicing and the slicers should be synchronized. One slicer should be type Between and other Dropdown list.

Is it posible to synchronize these two slicers? (differnet pages, the same page)

 

I tried to do this, but was not sucessfull. I added these two slicer to one or more pages, after that in the Sync Slicers pane, I set in the Advanced part one group with the same name. But after this setting both slicers change to same type - means that the type change was aplied to other slicer. Have tried to change the setting with additional option Sync field changes.... or Sync filter change.... but this not worked. 

Any idea how to do this?

thanks

 

4 REPLIES 4
lbendlin
Super User
Super User

"Sync slicers"  is limited to slicers with the same name and the same source.

will the sync slicers work if i have two tables say "sales" and "target" and both have a date column and are kept as slicers in one single page . if i choose "2018" in 'slicer1' which is from sales table and the 'slicer2' should automatically gets selected with the year "2018".

 

I have referred this from powerbi documentation but still it is not working. Any suggestion or ideas would be good
Slicers in Power BI - Power BI | Microsoft Learn

No.  Use your data model's calendar table to control the date columns in your tables

Thank you, but this in not, what i'm asking, I you would like to read by post you will see, that i done this.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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