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.
Hi all,
If I have a report where new data is added daily with the date in column A, how do I always get the current date of today in a dashboard?
Solved! Go to Solution.
HI @Frixel,
You can click on 'view' menu to find out the option to open formula bar or click on the advanced editor to check these formulas and modify them.
Regards,
Xiaoxin Sheng
Hi @Frixel,
You can also add 'today' filter in the query editor side.
Steps:
1. Enter to query editor and click on the date field that you want to filter records and choose one date to apply filter.
2. Modify on formula bar to replace that value with Date.From(DateTime.LocalNow())
Notice: My table does not contain today value so it has been filtered as blank, this filter will update based on your system DateTime.
Regards,
Xiaoxin Sheng
HI @Frixel,
You can click on 'view' menu to find out the option to open formula bar or click on the advanced editor to check these formulas and modify them.
Regards,
Xiaoxin Sheng
Hi, in order to have today's data in a dashboard you need to filter a visualization by today before pinning it to the dashboard. You can check this post about relative date to understand how you can filter by "this day" and a lot more.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Regards,
Happy to help!
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 |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |