How to set a dynamic default date range in a slicer?

[BigLo]

Hello,

I'm using a date slicer, and I've noticed that when I select a specific date (rather than all available dates), the slicer gets locked to that selection and doesn't update dynamically.

Is there a way to make the slicer default to a dynamic range, such as the last 30 days?

Ideally, I'd like users to be able to expand the date range if they want, but when the dashboard first loads, it should automatically show only the last 30 days.

Is it possible?

[Ahmedx · Accepted solution]

pls try

[ThomasWeppler · Accepted solution]

Hey BigLo

Here is how you set it to the last 30 days

I hope this help. If this solve your problem please accept this as a solution.

[v-hashadapu]

Hi @BigLo , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

[BigLo · Accepted solution]

It works.

However, our users typically use a date picker; therefore, I would have preferred a date filter with dynamic selection.

I will use relative dates (with a StartDate/EndDate display) or a custom visualization.

Thank you for your answers

[v-hashadapu]

Hi @BigLo , Thanks for the update and the information. If you have any other queries, always feel free to create a new post. We are always happy to help.

[v-hashadapu]

Hi @BigLo , Thank you for reaching out to the Microsoft Community Forum.

We find the answers shared by @MasonMA and @ThomasWeppler  are correct. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.

Thank you @MasonMA & @ThomasWeppler  for your valuable response.

[MasonMA]

Hi, 

I'd suggest using 'Relative date' if your dynamic range is relative to today. Using a Relative Date slicer always auto-updates in Service.

[ThomasWeppler · Accepted solution]

Hey BigLo

Here is how you set it to the last 30 days

I hope this help. If this solve your problem please accept this as a solution.

[Ahmedx · Accepted solution]

pls try