Default ACTUAL latest date in the slicer

[powerbiuser444]

Hi there!

There are similar topics but I didn't find a solution I'm looking for.  I need to see an ACTUAL latest date by default in the slicer, not "Latest date" category. So I used this calculated column LatestDate=IF([Date]=MAX([Date]), "Latest Date", [Date]&""). This works fine but I need to see an actual date in the slicer say Feb 6, 2021, instead of "Latest Date". I used the same logic LatestDate=IF([Date]=MAX([Date]), MAX([Date], [Date]) but it didn't work. Please help with how to fix the expression.

[lbendlin]

You simply cannot do that any other way than by calculating the column and specifying a static value like "Latest Date". 

Raise an idea if you don't like that.