Power BI Date Slider How to Show Latest date as Start and End

[RKM]

Hi There,

I have following Date Picker slicer coming from "Transaction_Date" column.

I want by default when user will open report it will show latest Transaction Date On both Start and End.... i.e. only 1 day date range and latest. For example, today it should show "14-JUN-2023" and both Start and End.... But they should have the option to alter/adjust start and end as per their choice.

How this could be done?

I understand, I can create a New derived column and over there I can calculate "latest date" and rest of days and then create a Dropdown Filter with default "Latest Date" selected while publishing etc.... but that one we can not use in Slider right.... I prefer to use a slider. Any option?

[RKM]

Thanks for your response @amitchandak 

Still I am unclear how my concern could be addressed. As I mentioned...

"...I understand, I can create a New derived column and over there I can calculate "latest date" and rest of days and then create a Dropdown Filter with default "Latest Date" selected while publishing etc.... but that one we can not use in Slider right.... I prefer to use a slider. "

[amitchandak]

@RKM , Try if this approach can help

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...