how to force slicer to always update with today's date?

[mj2024]

Hi

I have a slicer that enters a start and end date:

The start date doesn't change often.  However, I have to change the end date each time I start up PowerBI because I want the latest data.  It would be very helpful if the end date always updates to today's date.  This way each time I start up PowerBI it will have the latest date.  There are occasions when I have to override this logic and if that happens then I can manually enter an end date.  The default value should be today's date.  How can I do this?

Thank you

[Anonymous · Accepted solution]

Hi @mj2024 ,

1. Assuming you want a dynamic date range from the minimum date to the maximum date, you can click this eraser button in PBI Desktop and republish it again:

2. If you are wanting to dynamically date range from this year to today. Then you can introduce visual's filter and bookmarks to achieve this.
create a silcer:

create bookmark1. and then create a new measure:

Measure = 
VAR __today = TODAY()
VAR __first_Day_Year = DATE(YEAR(__today),1,1)
VAR __selected_Date = SELECTEDVALUE('Date'[Date])
VAR __result = IF(__selected_Date>=__first_Day_Year && __selected_Date<=__today,1)
RETURN
    __result

apply it to the slicer's filter:

create bookmark2. and rename bookmark1 and 2. insert bookmark navigator:

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Ritaf1983]

Hi @mj2024 
You can create a flag measure like :

flag_last_transaction = if(max('Calendar'[Date])>max('orders'[Order Date]),0,1) 
Or same logic by last transaction:

flag_last_transaction = if(max('Calendar'[Date])>max('orders'[Order Date]),0,1)

and use it as a filter for the slicer :

The pbix with the example is attached

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

[some_bih]

Hi @mj2024 one possible option is to use filter for Relative date, like on picture below. Set it according to your data /requirements.