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 f...
Need Help
Tips and Tricks
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.