topic Re: DateSlicer "Between" + MaxDate in DAX Commands and Tips

DateSlicer "Between" + MaxDate

cn4422 — Mon, 07 Apr 2025 12:30:05 GMT

Hello,

I’m using a date slicer with the "Between" setting to provide more flexibility.

However, when the dataset is updated, the selected end date remains fixed on the previously selected date.

What I want is for the end date to automatically jump to the latest available date whenever the dataset is refreshed — similar to how it behaves when using the "After" setting in the slicer.

I've tried to create this and put it into the visual-filter with = 1.

Datum_Filter =

IF(

'MaxDatum'[LetztesDatum] >= DATE(2025,1,1) && 'MaxDatum'[LetztesDatum] <= TODAY() - 1,

)

But it doens't work when the data is refreshed.

Any idea on how to solve this?

Thx in advance! 🙂

Re: DateSlicer "Between" + MaxDate

bhanu_gautam — Mon, 07 Apr 2025 12:54:31 GMT

cn4422 Create a measure that calculates the maximum date in your dataset. This measure should always return the latest date available in your data.

Max Date = MAX('YourTableName'[DateColumn])

Use this measure in a new measure that adjusts the end date of your slicer based on the maximum date in your dataset.

Adjusted End Date =
IF(
SELECTEDVALUE('YourTableName'[DateColumn]) = MAX('YourTableName'[DateColumn]),
MAX('YourTableName'[DateColumn]),
SELECTEDVALUE('YourTableName'[DateColumn])
)

Update your visual-level filter to use the "Between" setting with the start date as the minimum date in your dataset and the end date as the "Adjusted End Date" measure.

Re: DateSlicer "Between" + MaxDate

v-saisrao-msft — Wed, 09 Apr 2025 04:04:49 GMT

Hi cn4422,
I wanted to check if you had the opportunity to review the information provided by bhanu_gautam. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Re: DateSlicer "Between" + MaxDate

v-saisrao-msft — Sat, 12 Apr 2025 07:15:13 GMT

Hi cn4422,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: DateSlicer "Between" + MaxDate

cn4422 — Mon, 14 Apr 2025 07:25:44 GMT

Hi bhanu_gautam ,

thanks for your reply and sorry for my late reply. 🙂

I've created the two measures as suggested:

Max Date = MAX('MaxDatum'[LetztesDatum])

Adjusted End Date =

IF(

SELECTEDVALUE('MaxDatum'[LetztesDatum]) = [Max Date],

[Max Date],

SELECTEDVALUE(MaxDatum[LetztesDatum]

))

However, I'm not sure how to achieve this:

Update your visual-level filter to use the "Between" setting with the start date as the minimum date in your dataset and the end date as the "Adjusted End Date" measure.

Where can I set a specific date with the "Between" setting?

Re: DateSlicer "Between" + MaxDate

cn4422 — Mon, 14 Apr 2025 07:25:03 GMT

Hi v-saisrao-msft ,

thanks for the reminder - it took me a while - but I just replied to the user's suggestions.

Re: DateSlicer "Between" + MaxDate

divyed — Mon, 14 Apr 2025 11:45:20 GMT

Hello cn4422 ,

You have couple of options available and I have covered in a similar post, here is the link :

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Autometic-set-Date-Splicer-from-date-mm-dd-yyyy-to-today/m-p/4594437#M175935

You can modify slightly to show max date instead of today, Kindly check and let me know.

I hope this helps.

Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.

Warm Regards,

Neeraj

Re: DateSlicer "Between" + MaxDate

v-saisrao-msft — Tue, 15 Apr 2025 10:31:10 GMT

Hi cn4422,

Thank you for reaching out to the Microsoft Fabric Forum Community.

The response accurately addresses the OP's issue in part but doesn't fully meet the requirement. Using a visual-level filter with a DAX measure (Max Date) to cap the data at the latest available date while keeping the "Between" slicer for custom date ranges is a valid solution and directly addresses the OP's concern.
The Relative Date slicer is a dynamic alternative, but it sacrifices flexibility by only allowing predefined relative periods (like "Last X days") instead of custom start and end dates, which doesn’t fully align with the OP’s need.
The "Before" slicer is less relevant, as it doesn’t provide the same flexibility for selecting a custom date range. While bookmarks offer a manual reset option, it doesn’t solve the OP's requirement for an automatic update to the end date after a dataset refresh. Overall, the visual-level filter solution is the most accurate, but the Relative Date slicer suggestion may not fully meet the OP's needs for flexibility in date range selection.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.