Forum Discussion
Default current data update in power bi
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 :)
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.:smileyhappy:
IsLatestDate = IF ( DateTable[Date] = CALCULATE ( MIN ( DateTable[Date] ), ALL ( DateTable ) ), "LatestDate", "OtherDates" )Regards
1 Reply
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.:smileyhappy:
IsLatestDate = IF ( DateTable[Date] = CALCULATE ( MIN ( DateTable[Date] ), ALL ( DateTable ) ), "LatestDate", "OtherDates" )Regards