default slicer selection should be latest date when we open the report

[Anonymous]

default slicer selection should be max(date) when we open the report. below dax is working but the calculated column is text like "Latest Date" but i need max(date). Need urgent help on this requirement.

working fine: _Date_slicer =

IF('Date'[Date] = MAX('Date'[Date]), "Latest Date", FORMAT('Date'[Date], "MM-DD-YYYY"))

 

not working:

 IF('Date'[Date] = MAX('Date'[Date]), MAX('Date'[Date]), 'Date'[Date])

[amitchandak]

@Anonymous , the second one is working, it is giving the 1-April Date. But you can not default

The one gives a fixed text value which you can save in the slicer

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

[Anonymous]

@amitchauhan 

Hi Amit,

in that video, he is creating this year, this month, today or yesterday, but i use these calculated column into another dax measure then it will not filter the data and it wont compare the data with text and integer. because of this reason

i required default latest date should be selected in slicer when i open the report. this is the requirement