The default slicer selection as MAX Date

[SushmaReddy]

Hi Team,

I got a requirement where the slicer selection should be the the max date by default where the remaining dates also be displayed for further selection as shown below.

Able to get the max date using dax but when i use that DAX in the slicer,it is showing only the Max date which is not the requirement.All the dates has to be shown and Max has to be selected by default.Please help to resolve the issue.

Best Regards,

Sushma

[amitchandak · Accepted solution]

@SushmaReddy , You have to create a column like this

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

And save it on Max date