filter with default open to last date

[Giada_Togliatti]

Hi,

I have a filter with field date.

Is it possibile to setting up a default open to a filter as last date available so if the database updates if I open the workbook I have always the last date selected?

Thank you

[Naash]

First you need to create a measure that selects the latest date value and then use this measure as an input to create a calculate column in power bi

Measure
max_date= 

CALCULATE(LATEST_DATE(Data[Date]),ALL(Data))

Calculated Column
recent_date=

if([max_date]=Data[Date],"Latest_Data","Historic_Data")

And then you can use this column as a value in "Filter on this page" over the Filter section and select the default value as "Latest_Data" and lock the filters. By doing so the only the recent data would be displayed

[amitchandak]

@Giada_Togliatti , You can have a column like this in date table

Is Max= if('Date'[Date]=max(Table[Date]),"Last Date",[Date]&"")

You can select last date -Last Date

You can sort this column on Date

[Giada_Togliatti]

@amitchandak, could you send me a sample workbook with the solution, please?

[v-yiruan-msft]

Hi @Giada_Togliatti ,

It is currently impossible to achieve if set the maximum date as the default option for the filter or slicer directly. You can refer the solution in the following threads as workaround to achieve it.

Default slicer selection(Latest date) in Power BI

Select latest date in Slicer

max value selected in date slicer

In addition, here is one similar idea shared on Power BI Ideas, you can vote it up and add your comments there to improve Power BI on this feature. You can also raise a new one.

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.