Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
cn4422
Helper V
Helper V

Dynamic Dateslicer with Bookmark for 2 years

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,
    1,
    0
)

 

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! 🙂

 

 

 

date slicer.png

2 REPLIES 2
Anonymous
Not applicable

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.

vmengmlimsft_0-1742541201607.png

vmengmlimsft_1-1742541213484.png

 

 

 

 

Best regards,

Mengmeng Li

@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?

 

date slicer 02.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.