Slicer default to latest date of a column

[susheel1347]

Hi All,

I am trying to have the default date of the slicer to latest date of the column and it should have option to select different date later if user wants. The data of the column changes everyday & adds latest dates. I am struck. Can you please help?

[v-shex-msft]

Hi @susheel1347, 

I think Greg_Deckler 's format should suitable for your requirement.
I modify his formula to compare with the last date form your table and marked it as 'last'.  You can use this as the source of slicer, The '.last' option will be fixed on the top of the slicer lists and recalculated when your table records changes.

Marked =
IF ( [date] = MAXX ( ALL ( Table ), [date] ), ".Last", [date] & "" )

Regards,

Xiaoxin Sheng

[Greg_Deckler]

@susheel1347 You can use a relative date slicer or create a column that identifies "current" and "other" and add add a slicer for that.

[susheel1347]

@Greg_Deckler  Thanks for the reply. I am looking for single selection slicer & default date. 

[Greg_Deckler · Accepted solution]

@susheel1347 So, it sounds like you want this:

Column = IF([Date]=TODAY(),"Today",[Date]&"")

Then you would need to set the slicer to "Today" and save the report. Now Today will always be the default in the report and what rows are "Today" will change over time as the data is refreshed. 

[amitchandak]

@susheel1347 , You have no option to do that, You can create a column like this and use that in filter

Date Type =
SWITCH(TRUE(),
'Date'[Date] = TODAY(), "Today",
'Date'[Date] = TODAY() -1 , "Yesterday",
[Date]& "")

[susheel1347]

@amitchandak  Thanks! I can create a column but it will not be defaulted to latest.