Forum Discussion
Giada_Togliatti
Post Patron
Post Patronfilter with default open to last date
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 se...
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=
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