Custom default date on date range slicer

[Anonymous]

Hi,

I want to show default date range slicer for eg - if the max and min date in the table is 1st Jan 2022 and 19th April 2022 then I want to default the slicer to show latest 1 week date range ie from 13th April 2022 - 19th April 2022 but the users should be able to slide the date to any date between 1st Jan 2022 - 19th April 2022.

Is it possible to do something like this in date range?

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

I failed to add a filter on the date range slicer.

I'm afraid it's a not supported feature currently.

Measure = 
var _date = SELECTEDVALUE('calendar'[Date])
var _max = MAXX(ALLSELECTED('calendar'),'calendar'[Date])
return
SWITCH(SELECTEDVALUE(default[default]),"latest_week",IF(_date<=_max&&_date>_max-7,1,0),"all",1)

You may consider to submit this as an idea.

https://ideas.powerbi.com/ 

Best Regards,

Jay