Forum Discussion
Issue: Slicer Sync Forces Same Format Across Pages (Between vs Relative Date)
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.
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
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.
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 selectionPlease 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.
