topic Default selection of the most recent date in Power BI slicer after dataset refresh in DAX Commands and Tips

Default selection of the most recent date in Power BI slicer after dataset refresh

D_Khandelwal — Tue, 04 Apr 2023 12:30:27 GMT

Hello All,

I've a date dropdown filter (with single selection) and I want to set its default value to the most recent date after every refresh. I've researched a lot about this but couldn't find any perfect fit, I've tried below code as well

Date 2 = IF('Table'[Date] = MAX('Table'[Date]), "Recent Date", FORMAT('Table'[Date], "MM-DD-YYYY"))

but the problem is I don't want a plan text "Recent Date", so I tried to append Recent Date as text along with the text "Recent Date" e.g., "Recent Date 04/04/2023" but in that case after refresh I got 2 values (Previous latest date and the current one after refresh) and so I've to again manually change the date from the dropdown, see below for reference.

IF('Calender table'[Date] = MAX('Calender table'[Date]),CONCATENATE("Recent Date ", (FORMAT('Calender table'[Date], "MM/DD/YYYY"))),FORMAT('Calender table'[Date], "MM/DD/YYYY"))

If anyone have any solution then please help me out with this,

Thanks,

Dinky

Re: Default selection of the most recent date in Power BI slicer after dataset refresh

amitchandak — Tue, 04 Apr 2023 08:50:12 GMT

D_Khandelwal , Because of current limitation of slicer , you have use a column like

IF('Calender table'[ValuationDate] = MAX('Calender table'[ValuationDate]),"Latest Date ",FORMAT('Calender table'[ValuationDate], "MM/DD/YYYY"))

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

Re: Default selection of the most recent date in Power BI slicer after dataset refresh

D_Khandelwal — Tue, 04 Apr 2023 09:10:55 GMT

Thanks for your response amitchandak ,

I understand thats its the limitation but there's no other workaround for this ??
I go through the blog you shared but as mentined I need to specify the date as well along with the text or else the most recent date should be selected (Without text).

Thanks,

DInky