Max Date by Default in Slicer

[itcloud_Learn]

Hi

I have an requirment i need to have Date Slicer which has to show Max Date Value by default, But slicer has option to select different dates also.
So by default Max date has to show and we can select other dates too. Data type should be Date only. Can you please suggest

my requirement is Date is coming from database table which has to be by default max date value in the slicer but we can the option to choose or select different dates as well. For the date columns example today date (max date) 18-05-2023 by default it has to show but if i have to change or choose any other date like last month date like 30-04-2023 or any other date. Date Slicer should be in Date(calendar) format data type should be date only not any text.

[amitchandak]

@itcloud_Learn , As of now you have to use this work around

Date Type = SWITCH(TRUE(),'Date'[Date]=max(fact[date]),"Max Date"
,'Date'[Date]&"")

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

[itcloud_Learn]

Thank you for reply,

I am getting the result in the form of List

but here the expecation is since the column is Date Data type the format should be in the form of calendar. Like below any suggestions

[Ahmedx]

see my solution here
https://community.powerbi.com/t5/Desktop/How-to-set-default-current-month-in-from-date-and-to-date-i...
Instead of VAR _today = TODAY()
write VAR _MaxDate = MAX('tabl'[sales])