Relative Time Issue When Using the Calendar Slicer

[brentjanss2]

I get this error across my various PBI desktop reports when I try to slice by the calendar view. I already made sure the dates are correct formats. This worked a week ago but when I recently logged into my computer, this happen and it happened across my reports using a calendar table. I can slice by dropdown by year or month but not by this slicer. 

[v-dineshya · Accepted solution]

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

[v-dineshya]

Hi @brentjanss2 ,

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

[v-dineshya]

Hi @brentjanss2 ,

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

[v-dineshya]

Hi @brentjanss2 ,

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

[lbendlin]

Hmm, can't reproduce with Version: 2.141.1580.0 64-bit (March 2025)

Which fields are in the failed visual? 

[brentjanss2]

forgot to include that. its a basic table of data. i have a many to one relationship between this table and the calendar table. the date fields are the same format. about a week ago, there were no issues with the data set or the calendar. now, the data set works fine in a table or matrix view, but i get this image in a column/bar view when I try to do relative time. i am confident the data set is not the issue

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.