Default slicer to a date (without filtering slicer)

[FerrariGolf]

Hi. I want the min date in the slicer to default to the two previous Saturdays (ie. if it's a Monday or Tuesday or Wednesday etc., it defaults to the second past Saturday). However, I still want the ability for the user to be able to select all dates if required, so I don't want to filter the slicer itself using relative dates.

In the attached picture, I've circled the date I want to default. For example (today is Tuesday, Aug 1st), I want the default date to be July 22nd. It would stay that default date until EOD Saturday (Aug 5th), then on Sunday (Aug 6th), it would default to July 29th.

Thanks in advance for the help.

[datawailor]

Yeah. kpost s right about default ynamic dtes. I'd sugest finding the ide that supports setting dynamic dates as its inceasingly become an issue to deal with.

Our approachhas bee o use formulas to apply a filter on the date field that updates based on the rules we applied similar t how the relative date filters work. A moreelegnt soltion isdesired but t does the job.

[kpost · Accepted solution]

It is not possible to add a dynamic 'default' selection range to a slicer.   By Dynamic I mean changing depending on the current date.

But you CAN add a button with a bookmark that will reset the slicer to a specific date range that is selected when the bookmark was updated.  So you'd have to (weekly) reset the slicer to the new saturday starting date, update the bookmark, and publish it.  Painful, I know....