Bookmarks for filter states in Power BI - Deep Dive

Overview - Bookmarks for filter states

What is it?

Bookmarks in Power BI are snapshots of your report's current view, including filters, slicers, and visual states. They let you save and quickly return to specific filter settings or visual arrangements. This helps you create interactive reports where users can jump to important views with one click. Bookmarks capture the exact filter states so you don't have to reset filters manually each time.

Why it matters

Without bookmarks, users must manually adjust filters and slicers to see different views, which is slow and error-prone. Bookmarks save time and reduce mistakes by remembering filter states exactly. This makes reports easier to explore and share, improving decision-making speed and accuracy. Bookmarks also enable storytelling by guiding users through key insights with preset filters.

Where it fits

Before learning bookmarks, you should understand how filters and slicers work in Power BI. After mastering bookmarks, you can explore advanced features like bookmark groups, selection panes, and using bookmarks for report navigation and storytelling.

Mental Model

Core Idea

A bookmark is like a photo snapshot of your report’s filters and visuals, letting you return to that exact view anytime.

Think of it like...

Imagine you are reading a book and use a bookmark to save your page. When you come back, you open the book exactly where you left off. Power BI bookmarks do the same for report filters and views.

┌───────────────┐
│ Current Report│
│ View: Filters │
│ and Visuals   │
└──────┬────────┘
       │ Save Snapshot
       ▼
┌───────────────┐
│   Bookmark    │
│ (Saved State) │
└──────┬────────┘
       │ Apply Bookmark
       ▼
┌───────────────┐
│ Restored View │
│ with Filters  │
│ and Visuals   │
└───────────────┘

Build-Up - 6 Steps

1

Foundation

Understanding Filters and Slicers

Concept: Learn what filters and slicers do in Power BI reports.

Filters and slicers let you choose which data to show in your report. Filters can be set on pages, visuals, or the whole report. Slicers are interactive controls users click to filter data. They help focus on specific parts of the data.

Result

You can control what data appears in your visuals by adjusting filters and slicers.

Knowing how filters and slicers work is essential because bookmarks save their states exactly.

2

Foundation

What Are Bookmarks in Power BI

Concept: Bookmarks save the current report view including filters and visuals.

A bookmark captures the exact state of your report page: which filters are applied, which visuals are visible, and their settings. You create a bookmark by clicking 'Add' in the Bookmarks pane. Later, clicking the bookmark restores that saved state.

Result

You can save and return to specific filtered views without resetting filters manually.

Bookmarks act like memory snapshots, making report navigation faster and more reliable.

3

Intermediate

Saving Filter States with Bookmarks

Concept: Bookmarks remember the filter and slicer selections at the time of saving.

When you create a bookmark, it saves all filter and slicer settings on the page. For example, if you select 'Region = East' and 'Year = 2023', the bookmark saves these filters. Applying the bookmark later resets filters to these exact values.

Result

Users can jump to specific filtered data views instantly by applying bookmarks.

Understanding that bookmarks save filter states helps you design reports with quick access to key data slices.

4

Intermediate

Using Bookmarks for Report Navigation

🤔Before reading on: Do you think bookmarks can be used to create buttons that navigate between views? Commit to your answer.

Concept: Bookmarks can be linked to buttons to create interactive navigation in reports.

You can assign bookmarks to buttons or images. When users click these buttons, the report applies the bookmark, changing filters and visuals instantly. This creates a guided experience, like a menu or story flow.

Result

Reports become interactive with clickable elements that change views smoothly.

Knowing bookmarks can drive navigation unlocks powerful interactive report designs.

5

Advanced

Managing Multiple Bookmarks and Groups

🤔Before reading on: Do you think bookmarks can be organized into groups for better management? Commit to your answer.

Concept: Bookmarks can be grouped and managed to handle many saved states efficiently.

Power BI lets you create bookmark groups to organize related bookmarks. For example, group bookmarks by report sections or scenarios. This keeps the Bookmarks pane tidy and helps users find views quickly.

Result

Large reports with many bookmarks stay organized and user-friendly.

Understanding bookmark groups helps maintain clarity and scalability in complex reports.

6

Expert

Advanced Bookmark Settings and Limitations

🤔Before reading on: Do you think bookmarks save all report settings including drill-through and cross-filtering? Commit to your answer.

Concept: Bookmarks save many but not all report states; knowing their limits is key for advanced use.

Bookmarks save filter states, slicer selections, visual visibility, and spotlight. However, they do not save drill-through filters or cross-filtering interactions between visuals. Also, bookmarks can be set to include or exclude data, display, and current page settings. Understanding these options helps create precise user experiences.

Result

You can fine-tune bookmarks for exact behavior but must work around some limitations.

Knowing what bookmarks do and don’t save prevents surprises and helps design robust reports.

Under the Hood

When you create a bookmark, Power BI records the current filter and slicer selections, visual states (like visibility and spotlight), and page settings into a snapshot object. This snapshot stores references to filter values and visual properties, not the raw data. Applying a bookmark tells Power BI to reset the report page to these stored states, updating visuals accordingly. Bookmarks do not store data themselves but instructions to restore the view.

Why designed this way?

Bookmarks were designed to be lightweight and fast by storing only state references, not data copies. This avoids bloating report files and keeps switching views quick. The design balances flexibility with performance, allowing users to save many bookmarks without slowing reports. Some states like drill-through were excluded to keep complexity manageable and avoid conflicts with user interactions.

┌───────────────┐
│ User sets     │
│ filters &     │
│ visuals state │
└──────┬────────┘
       │ Create Bookmark
       ▼
┌───────────────┐
│ Bookmark      │
│ Snapshot of   │
│ filter &      │
│ visual states │
└──────┬────────┘
       │ Apply Bookmark
       ▼
┌───────────────┐
│ Report page   │
│ resets filters│
│ and visuals   │
└───────────────┘

Myth Busters - 4 Common Misconceptions

Quick: Do bookmarks save the actual data or just the filter settings? Commit to yes or no.

Common Belief: Bookmarks save a copy of the data filtered at the time of saving.

Reality: Bookmarks only save the filter and visual states, not the data itself.

Why it matters: Believing bookmarks save data can lead to confusion about report size and performance, and misunderstanding how data updates affect bookmarks.

Quick: Do bookmarks save drill-through filter selections? Commit to yes or no.

Common Belief: Bookmarks save all filter types including drill-through filters.

Reality: Bookmarks do not save drill-through filters or cross-filtering between visuals.

Why it matters: Expecting drill-through filters to be saved can cause broken navigation or inconsistent views when using bookmarks.

Quick: Can bookmarks be used only by report creators, or also by report consumers? Commit to your answer.

Common Belief: Only report creators can use bookmarks; consumers cannot interact with them.

Reality: Report consumers can use bookmarks if report creators add bookmark buttons or panes for interaction.

Why it matters: Misunderstanding this limits report interactivity and user empowerment.

Quick: Do bookmarks automatically update when filters change? Commit to yes or no.

Common Belief: Bookmarks update automatically to reflect current filter changes.

Reality: Bookmarks are static snapshots and do not update unless manually edited or recreated.

Why it matters: Assuming automatic updates can cause users to see outdated views and incorrect data.

Expert Zone

1

Bookmarks can selectively save data, display, and current page settings, allowing fine control over what changes when applied.

2

Using the Selection pane with bookmarks lets you toggle visual visibility, enabling complex storytelling and layered report designs.

3

Bookmark navigation can be combined with buttons and drill-through to create multi-step guided analytics experiences.

When NOT to use

Bookmarks are not suitable when you need to save dynamic user interactions like drill-through filters or cross-filtering between visuals. In such cases, use report page navigation, drill-through pages, or dynamic measures instead.

Production Patterns

Professionals use bookmarks to create report navigation menus, scenario comparisons, and guided storytelling. Bookmark groups organize views by business questions. Combining bookmarks with buttons and selection panes creates polished, user-friendly reports.

Connections

State Management in Web Applications

Bookmarks are similar to saving UI state snapshots in web apps.

Understanding bookmarks as UI state snapshots helps grasp how reports remember user choices and restore views quickly.

Version Control Snapshots

Bookmarks act like snapshots in version control systems, saving a point-in-time state.

Seeing bookmarks as snapshots clarifies why they don’t store data but only state references.

Memory Bookmarks in Reading

Bookmarks in reports function like physical bookmarks in books, saving your place.

This connection highlights the intuitive nature of bookmarks as a tool for quick return to important views.

Common Pitfalls

#1 Creating a bookmark without updating it after changing filters.

Wrong approach:

1. Set filters to Region = East
2. Create bookmark named 'East View'
3. Change filters to Region = West
4. Use 'East View' bookmark expecting West filters

// Bookmark still shows East filters

Correct approach:

1. Set filters to Region = East
2. Create bookmark named 'East View'
3. Change filters to Region = West
4. Update 'East View' bookmark to save new state
5. Use bookmark to restore East filters correctly

Root cause:

Bookmarks are static snapshots and do not update automatically when filters change.

#2 Expecting bookmarks to save drill-through filter selections.

Wrong approach:

Create bookmark after drill-through filter applied, then use bookmark expecting drill-through filter to persist.

Correct approach:

Use drill-through pages separately; bookmarks do not save drill-through filters, so design navigation accordingly.

Root cause:

Bookmarks do not capture drill-through or cross-filtering states.

#3 Assigning bookmarks to buttons without enabling 'Data' option in bookmark settings.

Wrong approach:

Create bookmark with filters, assign to button, but 'Data' option is off, so filters do not change on click.

Correct approach:

Ensure 'Data' option is enabled in bookmark settings to save and apply filter states when button is clicked.

Root cause:

Bookmark settings control what is saved; forgetting to enable 'Data' causes filters not to apply.

Key Takeaways

Bookmarks save the exact filter and visual states of a Power BI report page as snapshots.

They enable quick navigation and storytelling by letting users jump to predefined views with one click.

Bookmarks do not save data or dynamic interactions like drill-through filters, so know their limits.

Using bookmark groups and selection panes helps organize and enhance report interactivity.

Understanding bookmarks as UI state snapshots helps design better, user-friendly reports.