topic Re: default slicer selection should be latest date when we open the report in DAX Commands and Tips

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

Anonymous — Fri, 07 Apr 2023 02:48:09 GMT

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])

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

amitchandak — Fri, 07 Apr 2023 04:01:26 GMT

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

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

Anonymous — Fri, 07 Apr 2023 04:40:14 GMT

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