Forum Discussion

ahmedtauqeer300's avatar
ahmedtauqeer300
Regular Visitor
8 months ago
Solved

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.

  • danextian's avatar
    danextian
    8 months ago

    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

      •  

      •  

      •  

      •  

    ahmedtauqeer300

7 Replies

  • 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.

     

    • ahmedtauqeer300's avatar
      ahmedtauqeer300
      Regular Visitor


      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

      • danextian's avatar
        danextian
        Super User

        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

      •  

      •  

      •  

      •  

    ahmedtauqeer300

  • 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

  • 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.