Forum Discussion

__michiel's avatar
__michiel
Regular Visitor
2 years ago
Solved

Date slicer default to max date

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 

Need Help
Tips and Tricks

4 Replies

  • mohitkumawat's avatar
    mohitkumawat
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    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's avatar
      __michiel
      Regular Visitor
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.