Applying a default last date on a filter

[Anonymous]

Hello,

i'm developing a report, that naturally does calculations over a so called "report date".

I would like that, when the report is opened without a "report date" selected in its slicer, it assumes the value of the last existing report date for that column, so my doubt also is about using MAX or LASTDATE.

Thanks in Advance.

Regards

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Based on my research, it is not supported yet currently. There is an idea about that you can vote it up to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-or-tile-by-value-configura

BTW, We can create a calculated column as below to work around.

Column =
VAR maxdate =
    MAXX ( 'Table', 'Table'[Date] )
RETURN
    IF ( [Date] = maxdate, "Last date", FORMAT ( 'Table'[Date], "yyyymmdd" ) )