Is it possible to change the order of the dates presented in a date slicer, with a 'Between' set up?

[ST2022]

Hello, 

I have a date slicer in my dashboard that is set up so the user selects the start and end date. Because my data spans many years - 2012-2024, the default start date picker is 2012.

Therefore, if a user wants to set a date range just within 2024, they have to click many times to navigate the start date up to 2024. 

I.e. this is how my slicer looks by default:

But how I would like it to be set up is something like this (whereby, the start and end date ranges are defaulted to 2024, which is most likely when a user will want to set their date range to):

Is there any way to achieve this?

Thanks

[mh2587]

//create this measure and add in the visual filter and filter out to 1 
DefaultYear = IF(YEAR('Table'[Date]) = YEAR(TODAY()),1,0)

[ST2022]

Hi @mh2587 

Thank you for your suggestion. 

[Doodle · Accepted solution]

Before publishing your pbix file to the service, select the dates you want to appear as default in the filter... so maybe Jan 1 2024 to Dec 31, 2024.

then publish the report and that should be the default. 

if you want even more specific you could do Jan 1, 2024 to the current month end but then you have to open the file set the new end date every month.

[ST2022]

Hi @Doodle ,

Thanks for your reply and for this suggestion, I'll be sure to give this a try and this may well just do the trick! 😊

[Bibiano_Geraldo]

Hi @ST2022 ,

Unfortunately, the slicer visual doesn’t have a default value setting. However, you can create two separate slicers to make selection easier for your users. For instance, you can add one slicer for months and another for years to reduce the number of clicks required. If users need to select specific days, you can include an additional slicer for that.

If this reply help you, please accept as solution a nd give a Kudo.

thank you.

[ST2022]

Hi @Bibiano_Geraldo ,

Thank you for your reply! Although annoying, it's good to know that there isn't a simple solution / option that I'm simply missing. Thank you for this suggestion as well 🙂