topic Default date range slicer to past three years in Power BI in DAX Commands and Tips

Default date range slicer to past three years in Power BI

poojithas — Mon, 15 May 2023 10:12:54 GMT

Hi All,

I have a date slicer as date range with slider. Range starting from 2018 till date. My requirement is to default the date slicer to past three years. Users should also be having the flixibility to go back to older dates.

Note: My requirement is to default the dates and not restrict the dates

Could someone please let me know how to achieve this.

Thank you.

Re: Default date range slicer to past three years in Power BI

tamerj1 — Mon, 15 May 2023 13:35:27 GMT

Hi poojithas

Do you mean you want to default a measure or a visual to the last 3 years if the year slicer is not selected?

Re: Default date range slicer to past three years in Power BI

poojithas — Tue, 16 May 2023 05:49:14 GMT

Hi tamerj1

I would like to default all the visuals in the page and the slicer to be defaulted to last 3 three years also giving users flexibility to slide back to other older dates.

Thank you