March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello Power BI community,
would it be possible to have the date change automatically (on date slicer) in a report when it is refresh to show the current day's date. The user currently has the option on the date slicer to manually change the date, but I would like it to show the current day data when they open the dashboard. Thank you for the help.
hi @laehatlav
It couldn't achieve that set a default value for a slicer, becasue when you log out of Power BI and come back to a report, the same items will be selected as when you left.
here is the idea, please see detailed explanation in it:
For your case, I think the relative date slicer may meet your requirement.
Regards,
Lin
Refer to this post on how to approach this..
https://community.powerbi.com/t5/Desktop/Automatic-Update-of-Date-Filter/m-p/884655
If it helps, mark it as a solution
Kudos are nice too
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
70 | |
68 |