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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ahmedtauqeer300
New Member

Issue: Slicer Sync Forces Same Format Across Pages (Between vs Relative Date)

Dear Power BI Community,

I am facing a persistent issue while trying to configure two date slicers—one using Between format and another using Relative Date format—across different pages using the Sync Slicer pane.

Issue Summary:

  • I want Page 1 to have a Between Date slicer (From–To).

  • I want Page 2 to have a Relative Date slicer (e.g., Last 7 days, Last 30 days).

  • Both slicers use the same Date column, and both should sync only the date value, not the format type.

  • However, when I sync the slicers:

    • Changing one slicer’s format (e.g., setting Page 1 slicer to Between) forces the slicer on the other page to switch to the same format.

    • Even disabling "Sync filter changes to other slicers" does not prevent the format from syncing.

    • If slicers have different Group Names, they do not sync the date values at all.

    • If slicers have the same Group Name, the format is also synced, which breaks the requirement.

  • I also tried:

    • Using Date column directly

    • Using a date table

    • Using different visualizations

    • Making group name empty (but the sync option becomes disabled)

    • Using measures (Between does not support measures)

    • Rebuilding visuals from scratch
      Yet the issue continues.

Expected Behavior:

  • Slicers with the same Group Name should sync only the selected date values, not the visual format type (Between vs Relative).

Actual Behavior:

  • Slicer visual format type is also being synced, making it impossible to use “Between” on one page and “Relative Date” on another while keeping the selected date in sync.

Impact:

  • This prevents creating a “Reset Date” bookmark based on Relative Date while the main report page uses a Between Date slicer for user selection.

  • Breaks reporting design where different pages require different slicer formats but must share the same date context.

Please advise if this is a known limitation or a bug, and if there is any workaround.

2 ACCEPTED SOLUTIONS

Please follow the steps exactly as instructed. Copy the already synced slicer on the same page, then hide the original. What appears to be happening is that the slicer is being copied from one page to another before it is synced. Instead, first copy the slicer to the other page, sync it, then copy that synced slicer within the same page, and hide the original.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Jaywant-Thorat
Resolver IV
Resolver IV

 Workaround for Disconnected Relative Date Table

Step 1: Create a disconnected Relative Date table

-----DAX-----

RelativeDate = DATATABLE( "Label", STRING, "Days", INTEGER, { {"Last 7 Days", 7}, {"Last 30 Days", 30}, {"Last 90 Days", 90} } )

-----DAX-----

Step 2: Use a measure to apply the logic

-----DAX-----

Relative Date Filter = VAR SelectedDays = SELECTEDVALUE ( RelativeDate[Days] ) RETURN IF ( ISBLANK ( SelectedDays ), 1, IF ( MAX ( 'Date'[Date] ) >= TODAY() - SelectedDays, 1, 0 ) )

-----DAX-----

Step 3: Apply measure as visual-level filter

  • Filter where Relative Date Filter = 1

    Result:

    • Page 1 → Between Date slicer (real Date column)

    • Page 2 → Relative Date slicer (disconnected)

    • No sync conflicts

    • Full control

    • Bookmark-friendly

      +++++++++++++++++++++++++++++

      Did I answer your question? Mark my post as a solution! This will help others on the forum!

      Appreciate your Kudos!!

      Jaywant Thorat | MCT | Data Analytics Coach
      LinkedIn: https://www.linkedin.com/in/jaywantthorat/

      Join #MissionPowerBIBharat = https://shorturl.at/5ViW9

      #MissionPowerBIBharat
      LIVE with Jaywant Thorat from 15 Dec 2025
      8 Days | 8 Sessions | 1 hr daily | 100% Free

    •  

    •  

    •  

    •  

@ahmedtauqeer300

View solution in original post

7 REPLIES 7
v-veshwara-msft
Community Support
Community Support

Hi @ahmedtauqeer300 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

v-veshwara-msft
Community Support
Community Support

Hi @ahmedtauqeer300 ,

Thanks for reaching out to Microsoft Fabric Community.
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.

Kedar_Pande
Super User
Super User

@ahmedtauqeer300 

 

Yes, the behavior you’re seeing is effectively a limitation: slicer type is coupled to sync when group names match.​

There’s no setting today to “sync date values only, ignore visual type.”

Practical workarounds:

Don’t sync the date slicers; use bookmarks and/or page-level relative filters.

 

If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

Jaywant-Thorat
Resolver IV
Resolver IV

 Workaround for Disconnected Relative Date Table

Step 1: Create a disconnected Relative Date table

-----DAX-----

RelativeDate = DATATABLE( "Label", STRING, "Days", INTEGER, { {"Last 7 Days", 7}, {"Last 30 Days", 30}, {"Last 90 Days", 90} } )

-----DAX-----

Step 2: Use a measure to apply the logic

-----DAX-----

Relative Date Filter = VAR SelectedDays = SELECTEDVALUE ( RelativeDate[Days] ) RETURN IF ( ISBLANK ( SelectedDays ), 1, IF ( MAX ( 'Date'[Date] ) >= TODAY() - SelectedDays, 1, 0 ) )

-----DAX-----

Step 3: Apply measure as visual-level filter

  • Filter where Relative Date Filter = 1

    Result:

    • Page 1 → Between Date slicer (real Date column)

    • Page 2 → Relative Date slicer (disconnected)

    • No sync conflicts

    • Full control

    • Bookmark-friendly

      +++++++++++++++++++++++++++++

      Did I answer your question? Mark my post as a solution! This will help others on the forum!

      Appreciate your Kudos!!

      Jaywant Thorat | MCT | Data Analytics Coach
      LinkedIn: https://www.linkedin.com/in/jaywantthorat/

      Join #MissionPowerBIBharat = https://shorturl.at/5ViW9

      #MissionPowerBIBharat
      LIVE with Jaywant Thorat from 15 Dec 2025
      8 Days | 8 Sessions | 1 hr daily | 100% Free

    •  

    •  

    •  

    •  

@ahmedtauqeer300

danextian
Super User
Super User

Hi @ahmedtauqeer300 

Duplicate one of the slicers being synched and adjust its formatting as needed. Then hide the original slicer. Even when hidden, the original slicer will continue to sync.

danextian_0-1765962383642.gif

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

ahmedtauqeer300_0-1765964259997.png


I am using Sync slicer function.. when I am doing it both the slicer showing the same format. I wanna keep once slicer in Between date format and another slicer in relative date format even after both are sync.. I tried but both the slicer after sync showing the same format either between or relative date depending on our selection

Please follow the steps exactly as instructed. Copy the already synced slicer on the same page, then hide the original. What appears to be happening is that the slicer is being copied from one page to another before it is synced. Instead, first copy the slicer to the other page, sync it, then copy that synced slicer within the same page, and hide the original.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.