Date Picker always updated to current date (w/o using date slicer)

[Sun_123]

Hi all,

I would appreciate your help regarding the follwing challenge (I have already looked the forum up but couldn't find any appropriate solution thats fits). 

I have the follwing date picker in a couple of reports:

Whenever the report is opened, the data for the range March 1st until Apr 5th is shown - those dates were saved while working on the report. However, I would like to have the end date of the time range always being updated to today's date - meaning in this example March 1st until Apr 26th. 

The challenge here is that the users should still be able to choose the dates flexible while using the report- therefore a setting "last three weeks" etc. does not work. 
Is there a way to keep this date picker visual while always showing the current date?

Thanks a lot for your ideas and support in advance!

Chris

[Anonymous]

Hi  @Sun_123  ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
FILTER('Table','Table'[date]>=MIN('Table'[date])&&'Table'[date]<=TODAY())

Result：

2. Using After Slice, the last date is always the current date

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sun_123 , As far as I know, you can not initialize a date range slicer,

You can get this month, this year etc like

https://www.youtube.com/watch?v=hfn05preQYA

Log an idea : https://ideas.powerbi.com/ideas/