Dynamic default selection in date slicer

[Vaishali04]

Hi All,

I am showing latest 30 days in date slicer(selection  between option at UI) and want to keep max date in that 30 day range as deafult selection when a user opens PBI report. 

Has anyone came acroos same scenario?

Regards

Vaishali

[Anonymous]

Hi @Vaishali04 ,

Everything seems ok on my side ...Did you use TODAY( ) to return the latest value function or write a fixed value?

Could  you share your pbix file?

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Vaishali04 ,

Please take a look at this case for reference.

Or you could create a new Date table for Slicer (sort descending )and enable the "Single select" option. So that the latest date value will always be selected.

Then use the following formula and apply it to filter(set as "is 1") like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Vaishali04]

Hi @Anonymous,

with every refresh new data will be there in date slicer. But default selection still be 10/12/2020. With each refersh slicer won't pickup max date as selction. It will be stuch on 10/12/2020.

Regards

Vaishali 

[amitchandak]

@Vaishali04 , Best is you use relative date slicer

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Else if you want fix the date , to today, create a column like this in date table. Sort on date and select and save on Today

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