topic Re: Dynamic Dateslicer with Bookmark for 2 years in DAX Commands and Tips

Dynamic Dateslicer with Bookmark for 2 years

cn4422 — Thu, 20 Mar 2025 15:28:15 GMT

Hi,

I have a Date Slicer and want it to switch between 2024 and 2025.

Switching to 2024 is no problem, that works fine.

The problem starts with switching back to 2025...

I've tried setting a filter (is 1) for the slicer for the 2025 bookmark, but it's not dynamic.

Date_Filter=

IF(

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

)

The idea is simply that when the date is updated, that it still shows the today-1 date on the slicer when I click the 2025 button.

I don't know if this can be done diretly somehow on the slicer or rather with a DAX-Measaure?

Any help is much appreciated! 🙂

Re: Dynamic Dateslicer with Bookmark for 2 years

Anonymous — Fri, 21 Mar 2025 07:15:43 GMT

Hi cn4422 ,

I would suggest you to check if the filter is applied before the creation of the 2025 bookmark, when the user makes changes in the previous bookmark and creates a new bookmark, only then the changes will be saved in the next bookmark. This is my test and everything seems to work fine.

Best regards,

Mengmeng Li

Re: Dynamic Dateslicer with Bookmark for 2 years

cn4422 — Fri, 21 Mar 2025 08:07:47 GMT

Anonymous thanks for your reply.

The bookmarks work fine for me as well.

However, the problems start when I update the date.

As you can see in the screenshot: When I created the bookmark, "Last Date" was 17.03.2025 - I saved the bookmark and it showed 16.03.2025 (Today-1).

When some time later the data was updated, "Last Date" is 21.03.2025 and when I then click the 2025 Button it still shows the 16.03.2025 (which was the datewhen I initially created the boorkmark).

Does this Date-Update also work fine in your model?