Showing results for 
Search instead for 
Did you mean: 
gooranga1 Impactful Individual
Impactful Individual

Re-publishing Date Slicer as relative

I found a little thing today that flummoxed me for a few hours. 


I was republishing a pbix file where I had chnaged the date slicer to be a relative date slicer. No matter how many times I republished the report online would not update the date slicer which was still showing as a 'between' rather than 'relative'. 


Publishing to a test workspace worked fine no problem but the existing report would not update. Then I noticed that the 'reset to default' button was highlighted. I reset to defaut and it re-assigned the date slicer from between to relative.


I just thought I would post in case anyone else flails around for an hour wondering why the heck the format doesn't update!



slicer default.PNGReset to Default

DateSlicerDeploy.PNGdesktop version vs power bi service version 

Super User IV
Super User IV

Re: Re-publishing Date Slicer as relative

That is a good tip to know, that would be due to the Slicer states being saved as part of the "Reset to Default" so in order for it to forget the users setting it would then need to be reset.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog
Not applicable

Re: Re-publishing Date Slicer as relative

@gooranga1 You are awesome, thanks! Stumbled upon this problem today 😛

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.