cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rpredmore
Frequent Visitor

I want date slicer to end on today's date, but still be editable

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?

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

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())

 4.png

 

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.

FrankAT
Community Champion
Community Champion

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)

jthomson
Solution Sage
Solution Sage

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?

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!