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,
I am designing a report with a date range slicer. I want the slicer to automatically show a specific start date and end on today's date. However, I want the stakeholder I am designing the report for to be able to edit the date range if they choose to.
Example:
Today is September 23, 2020.
On the report I want the date range slicer to automatically show 01/01/2019 - 09/23/2020. When I open the report, the visuals should be showing me data points between these ranges.
If I come back tomorrow to look at the report I want it to automatically show me 01/01/2019 - 09/24/2020, etc.
However, I also need to be able to edit this date range while viewing the report, and so far I cannot find a way that this is possible. Does anyone have any ideas?
Hi @rpredmore ,
You may try to create a calculated table. The TODAY function will retrun the current date.
Table = CALENDAR(DATE(2019,1,1),TODAY())
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rpredmore
attached you'll find a pbix file with a dynamic date range. If you open this file and refresh it, it expands the date range to today in slicer.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Assuming you don't have data in your dataset from the future, you should be able to do this out of the box by just moving the beginning of the slider date range to where you want?
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |