Default current data update in power bi

[vsatamraju]

Hello Team,

I have three reports and one timeline slicer to set the time frequency.

My reports are frequently refreshed i.e twice a day .

Now, The problem here is when report got refreshed ,lastest data is updating but still the slicer is set to the old date and i need to adjust the slicer with latest date 😞

Is ithere any wasy to set the current date as today in power bi  .

Thanks for the help 🙂

[v-ljerr-msft · Accepted solution]

Hi @vsatamraju,

In this scenario, you should be able to use similar formula like below to create a calculate column in your Date table to flag if the date is the latest date, then use the created calculate column "IsLatestDate" as a Slicer with "LatestDate" selected on your report.

IsLatestDate =
IF (
    DateTable[Date] = CALCULATE ( MIN ( DateTable[Date] ), ALL ( DateTable ) ),
    "LatestDate",
    "OtherDates"
)

Regards