Forum Discussion
Helper IIIHow to set a dynamic default date range in a slicer?
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?
pls try
Hey BigLo
Here is how you set it to the last 30 daysI hope this help. If this solve your problem please accept this as a 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
7 Replies
v-hashadapuCommunity Support
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.
- ThomasWeppler
Impactful Individual
Hey BigLo
Here is how you set it to the last 30 daysI hope this help. If this solve your problem please accept this as a solution.
- MasonMA
Super User
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.
- Ahmedx
pls try
- 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.
BigLoIt 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.
