Filtro Lista desplegable

It's possible, but for a cost. You must create a calculated column that converts the dates to text format and replaces the maximum date with a constant string such as "Latest". Once you set that value as a filter on your splinter, it will always be selected when updating.

You will also need to sort that new column by another column, ideally by a date number column that you already have in the date table.

@Camilo_Munoz ,

You can a column like this in your chart

Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-TODAY(),"Today"
,'Date'[Fecha]-TODAY()-1,"Yesterday"
,'Date'[Fecha]&"")

select today

Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-Max(Table[Date]),"Last Date"
,'Date'[Fecha]&"")

Select The Last Date in The Slicer

Create one more column

Date1 - Date

and sort the date type on date1