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.

Progress0 / 11 steps

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

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

3

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

Visual: Slicer; Field = Region.

Expected Result

4

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

Select 'East' in the Region slicer.

Expected Result

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

6

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

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

Expected Result

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

8

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

Select 'West' in the Region slicer.

Expected Result

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

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

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

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