PowerBI between two dates slicer auto update to the latest date

[Hyuna_8000]

Hi everyone

I have a powerbi table where the data behind the table is refreshed on an hourly basis. There is also a date slicer for user to choose a date range. The date slicer uses the "Create Date" from the data, which also presents in the table.

However, I realise that everyday when the data is refreshed, the slicer date is stagnant and stays at the date when I manually changed it, because of the created date is not auto updated, the data from the table is not updated until I manually update the date slicer to the latest date.

For example, when I opened the powerbi table today (10/05/2025), the date on the right stayed as 08/05/2025(the date when I manually updated the slicer). You can also see there is a white space there.

Is there a way to make the date on the left the earliest created date, and the date on the right the latest date from the data? even when user manually update the slicer, when the "reset" button is clicked, the slicer should go back to the default arrangement. 

Thank you so much in advance for any tips/suggestions.