Filter can't be auto selected to the max

[GAPER]

here is the filter I have. I wish to set the default value as the max value in the data set. However i don't see that option... may i know why?

Thanks

[amitchandak · Accepted solution]

@GAPER , As of now we can not default date like that. Idea has been there for quite sometime

You can have a column like and save on Max Date, as of now
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

Date Type = SWITCH(TRUE(),'Date'[Date]=max(fact[date]),"Max Date"
,'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]=TODAY()-2,"2 Days Ago"
,'Date'[Date]&"")