topic Show Min and dynamic Max date in "Between" Slicer - override/update "Clear All Filters" Bookmark in DAX Commands and Tips

Show Min and dynamic Max date in "Between" Slicer - override/update "Clear All Filters" Bookmark

andy808 — Mon, 06 Mar 2023 17:01:36 GMT

I have a Date Table and currently have a Date Slicer showing First and Last Date (from [Date] Column in Date Table), works fine as I refresh and add new dates. The slicer adjusts to latest [Date]. Here it is 2//18/2023

But I have a "Clear All Filters" Bookmark button for the user which resets page (employer wants this feature) and even thought I add new end dates - when I click on "Clear All Filters" button - the slicer goes back to previous date 2/18/2023.

Results I need:

I need to keep the ability to reset the Date Slicer back to Min date 7/1/2022 (if user chooses 7/2/2022) but force the Max Date to be updated (example here is 3/6/2023) when clicking on the "Clear All Filter" bookmark. (i.e de-selecting Date Slicer visual from the Bookmark is not a solution)

How do I do this?

I tried adding DAX Filters to Date Slicer but it doesnt work when I click the Clear All Bookmark:

Max Date for Slicer = MAXX(

'Date Table',

'Date Table'[Date]

Thank you!

Re: Show Min and dynamic Max date in "Between" Slicer - override/update "Clear All Filters" Bookmark

MAwwad — Mon, 06 Mar 2023 17:07:46 GMT

One approach could be to create a measure that calculates the maximum date dynamically based on the current selection in the slicer, and then use this measure in the slicer instead of the actual date column.

For example, you could create a measure like this:

Max Date = VAR SelectedMinDate = MIN('Date Table'[Date]) RETURN CALCULATE(MAX('Date Table'[Date]), 'Date Table'[Date] >= SelectedMinDate)

Then use this measure in the slicer instead of the actual date column. When the user selects a new start date, the slicer will update to show dates from the selected start date up to the dynamically calculated max date based on the current selection.

When the user clicks on the "Clear All Filters" bookmark, you can reset the slicer selection to the minimum date and the dynamically calculated max date will update accordingly.

Re: Show Min and dynamic Max date in "Between" Slicer - override/update "Clear All Filters" Bookmark

andy808 — Mon, 06 Mar 2023 17:24:36 GMT

I created a calculated column in my date table using your measure, applied it to the Date slicer field and I got this: