Bookmarks for filter states in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants you to create a Power BI report where users can quickly switch between different filter views using bookmarks. For example, one bookmark shows sales filtered by Region = 'East', another by Region = 'West', and a third shows all regions.

📊 Data: You have sales data with columns: Date, Region, Product, Sales Amount.

🎯 Deliverable: Create a Power BI report with a sales chart and three bookmarks that save and restore filter states for Region: East, West, and All.

Sample Data

Date	Region	Product	Sales Amount
2024-01-01	East	Widget	100
2024-01-02	West	Gadget	150
2024-01-03	East	Gizmo	200
2024-01-04	North	Widget	120
2024-01-05	West	Gizmo	180
2024-01-06	South	Gadget	130
2024-01-07	East	Widget	170
2024-01-08	South	Gizmo	160

1

Step 1: Load the sales data into Power BI Desktop.

Use 'Get Data' > 'Excel' or 'CSV' to import the sample data table.

Expected Result

Sales data table appears in Power BI with columns Date, Region, Product, Sales Amount.

2

Step 2: Create a clustered column chart to show total sales by Region.

Visual: Clustered column chart; Axis = Region; Values = SUM(Sales Amount).

Expected Result

Chart displays total sales for each region.

3

Step 3: Add a slicer visual for the Region field to filter the chart.

Visual: Slicer; Field = Region.

Expected Result

Slicer appears with selectable regions: East, West, North, South.

4

Step 4: Set the slicer to filter Region = East.

Select 'East' in the Region slicer.

Expected Result

Chart updates to show sales only for East region.

5

Step 5: Create a bookmark named 'East Region' that saves this filter state.

In View tab, open Bookmarks pane > Add bookmark > Rename to 'East Region'. Ensure 'Data' option is checked.

Expected Result

Bookmark 'East Region' saved with Region filter set to East.

6

Step 6: Clear the slicer selection to show all regions.

Click the eraser icon on the Region slicer to clear filters.

Expected Result

Chart updates to show sales for all regions.

7

Step 7: Create a bookmark named 'All Regions' that saves this filter state.

Add bookmark > Rename to 'All Regions'. Ensure 'Data' option is checked.

Expected Result

Bookmark 'All Regions' saved with no Region filter.

8

Step 8: Set the slicer to filter Region = West.

Select 'West' in the Region slicer.

Expected Result

Chart updates to show sales only for West region.

9

Step 9: Create a bookmark named 'West Region' that saves this filter state.

Add bookmark > Rename to 'West Region'. Ensure 'Data' option is checked.

Expected Result

Bookmark 'West Region' saved with Region filter set to West.

10

Step 10: Add buttons for each bookmark to allow users to switch filter views easily.

Insert > Buttons > Blank; Assign Action > Bookmark; Select bookmark 'East Region' for first button. Repeat for 'West Region' and 'All Regions' bookmarks.

Expected Result

Three buttons appear on report, each switching the Region filter to East, West, or All when clicked.

11

Step 11: Test each button to confirm it changes the filter state and updates the chart accordingly.

Click each bookmark button and observe chart filter changes.

Expected Result

Chart updates correctly for East, West, and All regions when respective buttons are clicked.

Final Result

Power BI Report
+-----------------------------+
| [East Region] [West Region] [All Regions] |
|                             |
|  Sales by Region (Column Chart)            |
|  East: 470                               |
|  West: 330                               |
|  North: 120                              |
|  South: 290                              |
+-----------------------------+

✓East region has the highest total sales among the regions.

✓West region sales are significant but less than East.

✓Using bookmarks allows quick switching between filtered views without manually changing slicers.

Bonus Challenge

Add bookmarks for filtering by Product (Widget, Gadget, Gizmo) and create buttons to switch between these product views.

Show Hint

Create a slicer for Product, set filters for each product, create bookmarks saving those states, then add buttons linked to those bookmarks.

Practice

1. What is the main purpose of bookmarks in Power BI reports?

easy

A. To create new data tables automatically

B. To export reports as PDF files

C. To write DAX formulas faster

D. To save and recall filter and visual states easily

Solution

1. Step 1: Understand bookmark functionality

   Bookmarks capture the current state of filters and visuals in a report.

2. Step 2: Identify the main use

   They allow users to save and quickly return to these states without reapplying filters manually.

3. Final Answer:

   To save and recall filter and visual states easily -> Option D

4. Quick Check:

   Bookmarks = Save and recall states [OK]

Hint: Bookmarks save your current view for quick access [OK]

Common Mistakes:

• Thinking bookmarks create new data
• Confusing bookmarks with export features
• Assuming bookmarks write formulas

2. Which step is necessary to create a bookmark that saves filter states in Power BI?

easy

A. Use the 'Transform Data' option in Power Query

B. Apply desired filters, then click 'Add' in the Bookmarks pane

C. Export the report and import it again

D. Write a DAX measure to capture filter values

Solution

1. Step 1: Apply filters you want to save

   Set the report filters or slicers to the desired state.

2. Step 2: Add a bookmark

   Open the Bookmarks pane and click 'Add' to save the current filter and visual state.

3. Final Answer:

   Apply desired filters, then click 'Add' in the Bookmarks pane -> Option B

4. Quick Check:

   Create bookmark = Apply filters + Add [OK]

Hint: Apply filters first, then add bookmark [OK]

Common Mistakes:

• Trying to write DAX for bookmarks
• Exporting instead of bookmarking
• Using Power Query for bookmarks

3. Given a report with two bookmarks: Bookmark1 saves filter on 'Region = East', and Bookmark2 saves filter on 'Region = West'. What happens when you select Bookmark2?

medium

A. The report filters to show data only for the West region

B. The report shows data for both East and West regions

C. The report resets all filters to default

D. The report crashes due to conflicting filters

Solution

1. Step 1: Understand bookmark filter saving

   Each bookmark saves a specific filter state, including which region is selected.

2. Step 2: Effect of selecting Bookmark2

   Selecting Bookmark2 applies the saved filter 'Region = West', overriding previous filters.

3. Final Answer:

   The report filters to show data only for the West region -> Option A

4. Quick Check:

   Bookmark applies saved filter = West region [OK]

Hint: Selecting a bookmark applies its saved filters exactly [OK]

Common Mistakes:

• Assuming bookmarks combine filters
• Thinking filters reset to default
• Believing report crashes on filter change

4. You created a bookmark but when you select it, the filters do not change as expected. What is the most likely cause?

medium

A. The bookmark was saved without updating the filter states

B. The report data source is offline

C. Bookmarks only save visual formatting, not filters

D. You need to refresh the report to apply bookmarks

Solution

1. Step 1: Check bookmark saving process

   Bookmarks must be saved after applying desired filters to capture filter states.

2. Step 2: Identify why filters don't change

   If filters don't change, likely the bookmark was saved before filters were set or updated.

3. Final Answer:

   The bookmark was saved without updating the filter states -> Option A

4. Quick Check:

   Bookmark save timing affects filter capture [OK]

Hint: Always update filters before saving bookmarks [OK]

Common Mistakes:

• Blaming data source offline
• Thinking bookmarks don't save filters
• Assuming refresh applies bookmarks

5. You want to create a Power BI report that lets users switch between monthly and yearly sales views using bookmarks. Which approach correctly achieves this?

hard

A. Use Power Query to create separate tables for monthly and yearly sales and switch between them

B. Write a DAX measure that switches between monthly and yearly sales automatically

C. Create two bookmarks: one with monthly filters applied, one with yearly filters, then add buttons linked to each bookmark

D. Export the report twice with different filters and let users open the correct file

Solution

1. Step 1: Use bookmarks to save filter states

   Create one bookmark with monthly sales filters active, another with yearly sales filters active.

2. Step 2: Add buttons linked to bookmarks

   Add buttons or shapes that users can click to switch between these bookmarks easily.

3. Step 3: Confirm this enables switching views

   This setup allows interactive switching between monthly and yearly views without complex coding.

4. Final Answer:

   Create two bookmarks: one with monthly filters applied, one with yearly filters, then add buttons linked to each bookmark -> Option C

5. Quick Check:

   Bookmarks + buttons = interactive view switch [OK]

Hint: Use bookmarks plus buttons for easy view switching [OK]

Common Mistakes:

• Trying to switch views only with DAX
• Using Power Query instead of bookmarks
• Exporting multiple report files