Forum Discussion
Custom default date on date range slicer
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
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.
Best Regards,
Jay
1 Reply
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.
Best Regards,
Jay