Forum Discussion
Dates Between slicer default value to MAX date
If your Calendar table is built from MIN/MAX of the fact, then the slicer’s max is already aligned to your data, but Power BI does not provide a supported way to force a Between date slicer’s handles (From/To) to default to a relative range like 'MaxDate-1', 'MaxDate' each time a user opens the report. The Between slicer will default to the full available range unless the report is saved with a selection, and it won’t “recompute” that selection as “latest two days” on open.
I'd suggest using 'Relative Date' slicer set to “in the last 2 days” or “last 1 day” depending on inclusivity. This dynamically evaluates on open/refresh.
Hi Anonymous ,
Thank you MasonMA for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you.
Hi Anonymous ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.