Date slicer default to max date

[__michiel]

I have a date slicer in the Power BI service. 

The report contains data untill yesterday. If I save the report and open it the next day, the max date stays on the date of yesterday. So for example, today is 23 nov. 2023, so the slicer is on 22 nov. 2023. If I open the report tomorrow on 24 nov. 2023, the slicer is still on 22 nov. 2023. I want it to be on the maximum available date, which is 23 nov. 2023. 

Anyone knows how to accomplish this? 

Best regards,

Michiel 

[__michiel · Accepted solution]

Hi all, 

I finally found a solution. The key is to not change the date when you are editing your report, then Power BI will remember that selection. Better explained here in this video, all credits to Rosh. 

https://www.youtube.com/watch?v=D4AF9lQCick&ab_channel=PowerBIwithRosh 

Hope this helps others, it was driving me crazy! 

[mohitkumawat]

Hi  , create a date table as below,

date = CALENDARAUTO()

then add "date" from "date table",

or add "date" from main data table,

it all updates to the lastest data after the report refreshes.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[__michiel]

Hi, 

Thanks for your reply. This is the solution I have though, and this is when the problem occurs. So unfortunately no sollution for me. 

Thanks again for your input! 

[Anonymous]

Hi @__michiel ,

Try creating the following schedule:

Table = = CALENDAR(MIN('YourTable'[date]),TODAY())

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.