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
Community SupportHi 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.