# Adding Interactivity: Slicers, Filters, and Bookmarks

> Chapter 13 of the Courseiva PL-300 curriculum — https://courseiva.com/learn/pl-300/interactivity-and-bookmarks

**Official objective:** 3.2 — Configure interactivity with slicers, filters, and bookmarks

## Introduction

Exam objective 3.2 — Configure interactivity with slicers, filters, and bookmarks — is all about making your Power BI reports responsive to the person using them. Without these tools, a report is just a static picture of data; with them, it becomes a conversation, where the viewer can ask questions and get answers instantly.

## The Museum Curator Analogy

A museum curator is the person responsible for designing how visitors experience an exhibition. They don't change the artworks themselves, but they decide which paintings hang in which room, which labels appear next to each piece, and which guided tours take visitors through specific themes. The curator's job is to make sure every visitor can find exactly what they're interested in, without having to wander through every single gallery.

When a curator sets up a special display of Impressionist paintings, they are creating a 'slice' of the entire collection. They are saying: visitors who care about Impressionism can step into this room and see only those works, ignoring everything else in the storage vault. That is exactly what a slicer does in Power BI — it creates a dedicated space where report viewers can focus on a subset of data without seeing the full dataset.

The curator also uses filters to temporarily hide paintings that don't match a specific theme. If an art lover wants to see only landscapes from the 19th century, the curator might dim the lights on portrait paintings so they are still present in the room but not the focus. That is a filter: it hides data that doesn't meet the condition, but the data is still there, ready to be revealed.

Finally, the curator might create a guided tour that takes visitors through a sequence of rooms in a specific order, with specific commentary at each stop. That is a bookmark in Power BI — a saved state of the report that can be navigated to with one click, taking the viewer to a pre-configured view with particular slicers, filters, and visualisations already applied.

## Core explanation

In Power BI, a report is a collection of visualisations — charts, tables, maps, cards — all connected to a single dataset. When you first build a report, it shows everything, like a giant spreadsheet with every row and column visible. That is not helpful for decision-making. Your boss does not want to see sales for every product in every country at once. They want to see sales for their region, for their product line, for this quarter.

Slicers, filters, and bookmarks are the three main tools you will use to let report viewers pare down the data to exactly what they need. Each tool works differently, and each has a specific job.

A slicer is a visual control on the report canvas. It looks like a list, a dropdown menu, a date range, or a set of buttons. When a viewer clicks an item in a slicer — for example, clicking 'France' in a country slicer — every other visualisation on the page instantly updates to show only data for France. The slicer acts as a global gatekeeper for the page it lives on. It is the most user-friendly tool because it is visible and clickable. Viewers can see exactly what they are filtering by, and they can clear their selection easily.

Filters are more flexible and can be applied at different levels:
- Visual-level filters affect only one specific chart or table. If you have a bar chart showing sales by product, you can apply a filter so that chart only shows products with revenue over $10,000, while other visuals on the same page still show everything.
- Page-level filters affect every visual on one page. If you filter the page to show only data from 2024, every chart, table, and card on that page will respect that filter.
- Report-level filters affect every page in the entire report. This is useful when you are presenting to a specific team and you want the whole report to only show data relevant to them, like only the 'Americas' region.
- Drillthrough filters are special — they let a viewer click on a data point in one visual and jump to another page that shows detailed information about that specific item. For example, clicking on a sales total for a specific store might open a detail page showing that store's daily transactions.

Filters can be hidden from viewers (applied by the report creator in the Filters pane) or exposed for viewers to change themselves. The Filters pane is a panel that can be collapsed or expanded, showing all the filter rules currently in effect.

Bookmarks are like snapshots of the report's current state. If you have a page with slicers set to certain values, filters applied, and specific visuals visible, you can save that exact configuration as a bookmark. Later, anyone viewing the report can click that bookmark and instantly restore that exact state. Bookmarks can also control which visuals are visible, so you can create a 'before' and 'after' view of the same data by hiding some visuals in one bookmark and showing them in another. Bookmarks are stored in the Bookmarks pane and can be organised into a sequence for storytelling — this is called a 'bookmark navigation' experience.

Why does this matter? Because a static report forces every viewer to look at the same data. A dynamic report with slicers, filters, and bookmarks lets each viewer explore the data that is relevant to them. This is the difference between handing someone a printed report and giving them a live, interactive dashboard. For the PL-300 exam, you must understand how to configure all three, where to place them, and how they interact with each other.

## Real-world context

Imagine you work for a multinational retail company called ShopGlobal. Your manager, the head of European operations, asks you to build a sales performance report that the regional directors for France, Germany, and Italy can each use to monitor their own countries. They do not want three separate reports — they want one report that each director can customise.

Here is how you would use interactivity features:

First, you add a slicer for 'Country' to the top of the main report page. You set it to a dropdown style so it does not take up much space. Now, when the French director opens the report, they click 'France' in the slicer. Instantly, all the charts on the page — a bar chart of monthly sales, a map of store locations, and a card showing total revenue — update to show only French data. The German and Italian directors do the same for their countries.

But the French director also wants to see only stores that have revenue above a certain threshold. You cannot use the slicer for that because slicers work on discrete values like country names, not on continuous measures like revenue. Instead, you add a visual-level filter to the bar chart that hides any store below €50,000 in sales. That filter only affects the bar chart — the map still shows all stores, even low-revenue ones, because you want the director to see where underperforming stores are located.

Now, the Italian director wants a quick way to see the top 5 products by revenue. You create a bookmark called 'Top 5 Products'. Before saving the bookmark, you:
- Set the country slicer to 'Italy'
- Add a page-level filter to show only products in the 'Electronics' category
- Change the sorting on the product chart to descending by revenue
- Show only the top 5 using the visual filter

You save that configuration as a bookmark. Now, with one click, the Italian director can jump to that exact view without having to manually set all those filters every time.

You also set up drillthrough for the store map. When a director clicks a specific store on the map, they are taken to a detail page that shows that store's daily sales, inventory levels, and employee count. You achieve this by creating a drillthrough page with a drillthrough filter that passes the store name from the main page to the detail page.

Finally, you add button shapes on the report and assign bookmarks to them, creating a navigation bar at the top that says 'Overview', 'Top Products', and 'Store Details'. Clicking each button triggers the corresponding bookmark. Now the report is not just a collection of charts — it is a guided experience.

What traps should you avoid? One common mistake is putting a slicer on a page that also has report-level filters. The slicer will still work, but viewers may be confused when they cannot find certain values in the slicer because those values were already filtered out at the report level. Another trap is forgetting to set the 'Apply' button for slicers and filters when you want viewers to confirm their selections before the entire report refreshes. The PL-300 exam expects you to know when to use 'Apply' versus real-time filtering.

## Exam focus

The PL-300 exam tests your ability to configure interactivity in Power BI reports. For this objective (3.2), you can expect scenario-based questions where you are given a business requirement and must choose the correct tool or setting. Here is exactly what they test:

- Slicers: Know the difference between a slicer and a filter. The exam will present a scenario where a user needs to see a visual control on the report canvas that allows selecting single or multiple values. The correct answer is always 'slicer' if the requirement explicitly asks for a visible, clickable component. Traps: they might describe a slicer but call it a 'filter' in the answer choices. Always look for the word 'visual' or 'on the canvas'.

- Filter levels: You must be able to distinguish between visual-level, page-level, report-level, and drillthrough filters. A typical question: 'A manager wants a filter that affects only the current chart, not the other charts on the same page.' Answer: visual-level filter. Trap: they list 'page-level filter' as a distractor. Remember: visual-level affects one visual, page-level affects all visuals on one page.

- Bookmarks: The exam loves to ask about the 'Selection' and 'Data' panes within bookmarks. You need to know that a bookmark can remember:
  - Which visuals are hidden or shown (Selection pane)
  - The current state of filters and slicers (Data)
  - The current page
  - The sort order of a visual

A common trap question: 'Which pane must you use to control which visuals appear in a bookmark?' Answer: the Selection pane. The Data pane controls filters, not visual visibility.

- Cross-report drillthrough: This is a newer feature. PL-300 may test whether you know that you can drillthrough from one report to another, as long as both reports share the same dataset. This is done via the 'cross-report drillthrough' option in the drillthrough filter settings.

- Sync slicers: You may be asked how to make a slicer on one page affect a visual on another page. The answer is 'sync slicers', found under the View tab. Trap: they might say 'use a report-level filter' — but that is different because it forces the filter on every page. Sync slicers let you choose which pages are affected.

- 'Apply' button: Know when to use 'Apply' for slicers versus 'Apply all'. If a report has multiple slicers and the requirement is to wait until the viewer clicks a button to apply all filters at once, the correct answer is 'Apply all' (or setting the slicer to 'single apply' mode). Individual 'Apply' buttons apply only one slicer at a time.

- Bookmarks and buttons: The exam will ask how to create navigation between pages. You create a button, then assign a bookmark to it via the Action property. The button type must be 'Bookmark'. Trap: they might offer 'Drillthrough' as an answer — but drillthrough requires a different setup and only passes one value, not an entire view state.

- Performance considerations: You may be asked which interactivity feature is best for large datasets. Answer: filters (especially page-level) are more efficient than slicers because slicers require the report to query the dataset for distinct values every time the page loads. Slicers can slow down large reports.

- Trap for beginners: 'What happens if you apply a page-level filter and a visual-level filter to the same visual?' Answer: both are applied. The visual-level filter adds a condition on top of the page-level filter. The visual shows data that satisfies both filters.

- Key definitions to memorise:
  - Slicer: A visual filter on the canvas
  - Filter: A rule applied in the Filters pane, can be hidden or visible
  - Bookmark: A saved state of the report, including filters, visuals, and page
  - Drillthrough: A one-click navigation to a detail page based on a selected data point
  - Sync slicers: Feature to apply a slicer's selection across multiple pages

Do not confuse 'bookmark' with 'tooltip'. Tooltips are small pop-up boxes when you hover over a data point, not saved states. Also distinguish 'drillthrough' from 'drill down'. Drill down expands hierarchy (e.g., year to quarter), while drillthrough navigates to a different page.

## Step by step

1. **Identify the Viewing Audience** — Before adding any interactivity, determine who will use the report and what they need to see. For example, do regional managers need to see only their own region? This step defines the purpose: you will later choose slicers for categorical filtering, filters for numeric thresholds, and bookmarks for guided scenarios. Skipping this leads to unnecessary complexity.
2. **Add a Slicer for Categorical Data** — Drag a field like 'Country' or 'Product Category' from the Fields pane to the report canvas, then change the visualisation type to 'Slicer'. Configure the slicer style (dropdown, list, buttons) based on the number of values. This gives viewers a visible, clickable control to filter the entire page. Test by clicking a value and confirming all visuals update.
3. **Apply Page-Level Filters for Numeric Constraints** — In the Filters pane, drag a numeric field like 'Revenue' into the 'Filters on this page' area. Set the filter condition to 'is greater than' and enter a value. This hides all data below the threshold on every visual on the page. Unlike a slicer, this filter is not visible on the canvas unless you expose the Filters pane to viewers. Use this for performance optimisation — it reduces the data loaded.
4. **Create a Bookmark for a Specific View** — Set slicers and filters to the desired state (e.g., country = France, product category = Electronics). Open the Bookmarks pane (View > Bookmarks), click 'Add'. Give the bookmark a descriptive name like 'France Electronics Top View'. Optionally, in the bookmark's settings, choose which properties to capture: Data (filters and slicers), Display (visual visibility), Current Page, and Sort. Save. Now any viewer can click this bookmark to jump to that exact view instantly.
5. **Link the Bookmark to a Button for Navigation** — Insert a shape (e.g., a rounded rectangle) from the Insert tab. With the shape selected, open the Format pane and go to 'Button' > 'Action'. Set Action type to 'Bookmark'. Select the bookmark you created. Add text to the shape so it reads 'View Top Products'. Now when a viewer clicks this button, the report immediately navigates to the saved view, including all filters and slicers. This creates a user-friendly navigation experience without requiring manual filter adjustments.
6. **Set Up Drillthrough for Detail Pages** — Create a new page in the report and rename it 'Store Details'. In the Fields pane, drag a field like 'Store Name' to the 'Drillthrough filters' area of that page (under the Visualisations pane). Now go back to the main page, select a visual like a map, and enable drillthrough for that visual. When a viewer right-clicks or double-clicks a store data point, they will be taken to the 'Store Details' page filtered to that specific store. Add relevant detail visuals on that page (e.g., a table of daily sales).

## Comparisons

### Slicer vs Filter

**Slicer:**
- Visible on the report canvas as a visual element
- Viewer can interact by clicking or selecting values
- Only applies at the page level (unless synced)

**Filter:**
- Applied in the Filters pane, can be hidden from viewers
- Viewer can change values only if filter is exposed
- Can be set at visual, page, report, or drillthrough level

### Bookmark vs Drillthrough

**Bookmark:**
- Captures full report state including multiple filters and slicers
- Restores a saved view with one click or button press
- Can navigate to the same page or a different page

**Drillthrough:**
- Navigates to a detail page based on a single data point clicked
- Passes only one value as a filter to the target page
- Always navigates to a different page (target page)

### Page-Level Filter vs Visual-Level Filter

**Page-Level Filter:**
- Affects every visual on the current page
- Applied in the 'Filters on this page' area of the Filters pane
- Cannot be bypassed by slicers on the same page

**Visual-Level Filter:**
- Affects only one specific visual (chart, table, card)
- Applied in the 'Filters on this visual' area of the Filters pane
- Can be overridden by slicers if the slicer field is at a higher level

## Diagram

_This flowchart shows the three main interactivity mechanisms in Power BI — slicers, filters, and bookmarks — and how they affect the report at different levels._

```mermaid
flowchart TD
    A[Report Viewer] --> B{Interactivity Type}
    B --> C[Slicer]
    B --> D[Filter]
    B --> E[Bookmark]
    C --> F[Select Value]
    F --> G[All Visuals on Page Update]
    D --> H[Visual Level Filter]
    D --> I[Page Level Filter]
    D --> J[Report Level Filter]
    H --> K[Only One Visual Affected]
    I --> L[All Visuals on Page Affected]
    J --> M[All Pages Affected, Cannot Override]
    E --> N[Save Current State]
    N --> O[Click Bookmark to Restore State]
```

## Common misconceptions

- **Misconception:** Slicers and filters are the same thing — they both just hide data. **Reality:** Slicers are visual controls on the report canvas that viewers can click and interact with. Filters are rules applied in the Filters pane, which can be hidden from viewers or applied to specific levels (visual, page, report). They behave differently and are configured in different locations. (Both serve the purpose of limiting data, so beginners lump them together. But the exam tests the distinction between the visible, clickable slicer and the panel-based filter.)
- **Misconception:** If I clear a filter from the Filters pane, the bookmark I saved earlier will update automatically. **Reality:** Bookmarks capture a snapshot at the moment of saving. If you clear a filter after saving the bookmark, the bookmark still remembers the old filter. You must update the bookmark (right-click and choose Update) or delete and recreate it. (People expect bookmarks to behave like live views, but they are static snapshots. This confusion leads to reports where clicking a bookmark shows unexpected data.)
- **Misconception:** Drillthrough filters only work within the same page — you cannot go to another page. **Reality:** Drillthrough filters are specifically designed to navigate from one page to another target page. You configure the target page's drillthrough filter, and clicking a data point on the source page navigates there. It is a cross-page feature. (The word 'drill' suggests going deeper in the same visual (like drill down), so people assume it stays on the same page. But drillthrough is fundamentally about page-to-page navigation.)
- **Misconception:** You can only have one slicer per page. **Reality:** You can have as many slicers on a page as you need. Common reports have multiple slicers for different dimensions: a date slicer, a region slicer, a product category slicer. They all work together to narrow down the data. (Beginners see sample reports with one slicer and assume that is the limit. The exam may present a scenario with multiple dimensions and ask which interactivity tool to use — the answer is multiple slicers.)
- **Misconception:** If I apply a filter at the report level, viewers can still override it with a slicer on a page. **Reality:** Report-level filters cannot be overridden by page-level slicers. If you filter the entire report to show only '2024' data, a slicer for '2023' on a page will show no data because the data source already excludes 2023. Report-level filters are enforced first. (People assume slicers are the 'boss' because they are visible, but filters have a hierarchy: report-level > page-level > visual-level. Slicers sit at the page level and cannot remove report-level restrictions.)

## Key takeaways

- Slicers are visual controls on the report canvas that let viewers filter data by clicking, while filters are rules in the Filters pane that can be applied at visual, page, or report level.
- Bookmarks capture the exact current state of a report page — including slicer selections, filter settings, visual visibility, and the current page — and allow users to restore that state with one click.
- Drillthrough filters enable navigation from one report page to another detail page when a viewer clicks a specific data point, passing the clicked value as a filter to the target page.
- Report-level filters are the most restrictive and cannot be overridden by page-level slicers; they are applied before any other interactivity.
- Sync slicers feature allows a slicer placed on one page to control visuals on other pages without requiring separate slicers on each page.
- Visual-level filters affect only one specific chart or table, while page-level filters affect all visuals on that page — they can stack on top of each other.
- When using bookmarks for navigation, you must assign the bookmark to a button's Action property with the 'Bookmark' action type to enable click-based navigation.
- The 'Apply' button on slicers forces viewers to confirm their selection before the report refreshes, which can improve performance on large datasets by preventing real-time recalculation.
- Cross-report drillthrough allows navigation from a visual in one report to a target page in a different report, provided both reports use the same dataset.
- The Selection pane controls which visuals are hidden or shown in a bookmark, while the Data pane controls which filter states are remembered.

## FAQ

**What is the difference between a slicer and a filter in Power BI?**

A slicer is a visual control that sits on the report canvas and lets viewers click to select values. A filter is a rule applied in the Filters pane, which can be hidden or visible, and can be set at visual, page, or report level. Slicers are for user interaction; filters are for report-wide or page-wide constraints.

**Can I use a bookmark to go to a different page in the report?**

Yes, a bookmark can capture the current page state and navigate to that page when clicked. When you create a bookmark, ensure the 'Current page' property is checked. Then assign that bookmark to a button's Action property to enable click-based navigation to that page.

**How do I stop slicers from refreshing the report every time I change a selection?**

In the slicer's formatting pane, open the 'Slicer header' section and set the 'Apply' button to 'On'. This adds a button that viewers must click to apply their selection, preventing constant refreshes. For multiple slicers, you can set the slicer to 'Single Apply' to require manual application.

**What is the Sync Slicers feature and when should I use it?**

Sync Slicers allows you to have a slicer on one page control visuals on other pages without placing separate slicers on those pages. Use it when you want a consistent filter across multiple report pages, like a date range that remembers its selection as you navigate through the report.

**Can I make a slicer show only certain values, like top 10 products?**

No, a slicer always shows all distinct values from the underlying field. To show only top 10 products, you must apply a filter (visual-level or page-level) that limits the data. The slicer will then only display the values that remain after the filter is applied.

**What happens if I delete a field that a bookmark references?**

The bookmark will break and may no longer restore the correct view. Power BI will not automatically update bookmarks when fields are removed from the dataset. You must manually remove or update any bookmarks that reference deleted fields to avoid errors.

## Check your understanding

1. **Which Power BI interactivity feature should you use if you want viewers to see a visible dropdown list on the report canvas that they can click to filter the entire page?**

   Answer: You should use a slicer (configured as a dropdown style) because it is a visual control on the canvas designed for user interaction.

2. **If a report has a report-level filter restricting data to 2024 only, what happens when a viewer selects '2023' in a page-level slicer?**

   Answer: The slicer will show no data because the report-level filter is applied first and cannot be overridden by page-level slicers.

3. **What is the difference between a bookmark and a drillthrough filter?**

   Answer: A bookmark captures the entire current state of a report page (all filters, slicers, and visibility) and can be restored with one click. A drillthrough filter navigates to a detail page based on a single data point clicked by the viewer.

4. **How do you make a slicer on one page affect visuals on another page?**

   Answer: Use the Sync Slicers feature from the View tab. Add the slicer and select which pages you want to sync it to, so the slicer's selection is applied across those pages.

5. **When would you use an 'Apply' button on a slicer?**

   Answer: Use an Apply button when you want to prevent the report from refreshing every time the viewer changes a selection, improving performance on large datasets by requiring manual confirmation.

---

Interactive version with quiz and diagrams: https://courseiva.com/learn/pl-300/interactivity-and-bookmarks