Relative Time Issue When Using the Calendar Slicer

Hi brentjanss2 ,

Thanks for reaching out to the Microsoft fabric community forum. 

 

Please follow below steps to fix the issue:

1. Power BI Desktop Version/Update Bug:
Recent Power BI Desktop updates can introduce breaking changes, especially with custom visuals or slicer behavior. If this just started happening after an update.

Solution: Check your current version: File → About → Note the version number. Roll back to an earlier version that worked.

2. Model Refresh or Calendar Table Corruption:
Even if the dates are valid, the relationship between your fact table and calendar table might be broken or causing an issue when filtering by relative time.

Solution: Make sure the Date column in your Calendar table is marked as a Date Table. Ensure there is a valid relationship (usually Calendar[Date] → Fact[Date]). Test replacing the slicer with a new one from the field pane — it might be corrupted.

3. Visual or Filter Context Conflict :
Sometimes the error appears only in specific visuals due to incompatible filters or overly complex DAX measures that can’t handle dynamic relative ranges.

Solution: Rebuild the visual from scratch. Temporarily remove any complex DAX measures or filters being applied. Test in a new blank PBIX with the same slicer logic.

4. Regional/Time Zone Conflicts:
If your machine recently changed time zones, or Windows settings updated unexpectedly, relative slicers might behave erratically.

Solution: Check system date/time settings. Try switching the relative slicer to Absolute to confirm if the issue is with relative logic.

Need to check below steps:

1. Open your Calendar table → Ensure it's marked as a date table.

2. Rebuild the relative date slicer. Delete it and reinsert a fresh one from the Calendar table.

3. Start a blank PBIX → Import just the calendar table and try the same slicer. If it still fails, it's likely a software or system-level issue.

4. Check for Power BI Desktop updates (or roll back if recently updated).

5. Turn on “Performance analyzer” to check what’s crashing. (View → Performance Analyzer)

 

Please follow the Microsoft official document and community forum threads.

Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

Solved: Bug in Relative Date Slicer? - Microsoft Fabric Community

Solved: Relative Date filter is set to UTC, need to change... - Microsoft Fabric Community

 

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards