Date Between slicer won't update end date to today's date

[Neka]

Hello everyone,

I have a date slicer set to 'between' to show a beginning date and an end date. I want the end date to always update to today's date. However, it defaults to the date that the report was uploaded to the service. 

I want this:

But get this:

The slicer is filled by the date column in a date table which is connected to my main data table by their date columns. 

We want to send this report out to users via a subscription and it needs to show the most current data but instead is sending old data because of this issue.

Thanks for your help!

[Neka · Accepted solution]

To anyone looking at this for their own solution, this is what worked for me:
Go into your Power BI report on Desktop, delete your date slicer completely and then create it again. DON'T TOUCH THE SLIDER. Leave it exactly as is. Publish it to the service. Now my slicer always automatically updates to the current date. If you move the slider in your Desktop version, Power BI thinks you want to keep it on the date you selected. Hope this helps someone.

[johncpratt]

Thank you for posting your solution!  The following solution worked for me without deleting the slicers.  I have a linked date slicer on 4 pages:  https://community.fabric.microsoft.com/t5/Desktop/date-value-of-slicer-visual-not-updating-after-the... 

[GE1]

Is there a proper way to do this? Not being able to touch the slider is obviously a massive problem.

[Neka]

Unfortunately, this is the only way I have found to fix the issue. If I need to test the slider I will use it for testing, then delete it, and create a new slider before publishing. It's the only thing thats worked for me.

[Neka]

I also changed my date table so that it had dates in the future and used the above filter but it made no impact.

[Idrissshatila]

Hello @Neka ,

Refer to this solution https://community.fabric.microsoft.com/t5/Desktop/Date-slicer-slider-end-date-to-be-today/m-p/242196...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Neka]

I have this set up in the report already and it didn't work, unfortunately. Any other methods?

This is what I have set up.