Relative Date Slicer with Anchor Date not showing latest date when published

[Nickster424]

I have a relative date slicer with an anchor date set in the desktop file.

After publishing to Power BI Service, the report the date is not changing. I've tried to reselect all options in the slicer on the service and it remains at a prior date.

[Nickster424]

I deleted the slicer and added it back, published and it worked. Now I see that I could have also just cleared the selections.

Thank you all very much for the help!

[v-achippa]

Hi @Nickster424,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @jdbuchanan71, @Shahid12523 and @MohamedFowzan1 for the prompt response. 

Thank you for the response and confirming that the issue is resolved. I request you to please mark the above post or the post which helped you in resolving the issue as Accept as Solution so that other community members who has similar issue will find it more easily.

Thanks and regards,

Anjan Kumar Chippa

[MohamedFowzan1]

Hi @Nickster424 

Always clear or reset the anchor date in Desktop before publishing the PBIX to the Power BI Service.

[Shahid12523 · Accepted solution]

Your relative date slicer with an anchor date isn’t updating in Power BI Service because it keeps the last saved state from Desktop. To fix it:
- Clear slicer selection in Desktop before publishing
- Reset filters in Power BI Service after publishing
- Use dynamic DAX like TODAY() for auto-updating dates
- Consider a flag column like IsInLast26Weeks for consistent filtering

[jdbuchanan71]

It seems like the date table needs to refresh in the service, I can think of two things to try.

1. Refresh the model in the service.
2. Delete the existing report then republish