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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
scoder
Frequent Visitor

Custom date slicer with persistProperties commented

Iโ€™m currently stuck on a Power BI visualization issue related to bookmarks and slicers, and I have a unique requirement.

I have 3 funds: F1, F2, and F3, and Iโ€™ve created a Button for each fund.
Each fund has 3 different subpages: Overview, Projections, and Portfolio.
Each subpage contains visuals specific to that fund. (Attached sample image)

Iโ€™ve created bookmarks accordingly. However, the problem is with the Date slicer. Since bookmarks preserve the slicerโ€™s state, the date selection is always fixed to what was selected when the bookmark was created. I want the Date slicer to always default to the latest date from the date_dim table, regardless of the bookmark.

I tried unchecking the Data option in the bookmark, but that causes other issues. I have hidden slicers that dynamically filter the selected fund when the corresponding button is clicked. Disabling the Data option prevents those fund slicers from working correctly.

Each visual should display data only for the respective fund selected.

After some research, I found that this is a known limitation in Power BI โ€” you cannot exclude only one slicer (like Date) from a bookmark while retaining others.

As a workaround, I explored the idea of customizing a visual, such as the slicer from this GitHub repo:
https://github.com/microsoft/powerbi-visuals-timeline

I commented out the this.host.persistProperties line to stop it from persisting the selection state. But after building and uploading the custom visual to Power BI, it doesnโ€™t seem to work , is there other way to solve this problem? I need a date slicer with provision to exclude persistent or any different approach to this problem 

scoder_0-1752259929210.png

 

1 REPLY 1
johnbasha33
Super User
Super User

Hi @scoder 

You're absolutely right โ€” you're facing a classic Power BI bookmarks vs slicers conflict, and your use case is quite complex but not uncommon in real-world enterprise reporting.

To summarize your need:

  • You have buttons and bookmarks switching between funds (F1, F2, F3) and subpages (Overview, Projections, Portfolio)

  • You want fund filtering to be preserved via bookmarks

  • But you do not want the Date slicer state to be locked in by the bookmarks โ€” instead, you want it to always show the latest date

You're also right that Power BI does not currently support selectively excluding slicer state for specific visuals while keeping others โ€” the Data option in bookmarks applies to all slicers and filters.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)