Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |