Bookmarks for filter states in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data by region used to demonstrate filter states in bookmarks.

Cell	Value
A1	Region
B1	Sales
A2	North
B2	1000
A3	South
B3	1500
A4	East
B4	1200
A5	West
B5	1300

Formula Trace

Bookmark captures filter state: Region = 'South'

Step 1: Apply filter Region = 'South' to data

Step 2: Create bookmark capturing current filter state

Step 3: Clear filter and apply bookmark

Cell Reference Map

  A       B  
+-------+-------+
| Region| Sales |
+-------+-------+
| North | 1000  |
| South | 1500  | <-- Filter applied here
| East  | 1200  |
| West  | 1300  |
+-------+-------+

Filter is applied on the 'Region' column selecting 'South' row.

Result

  A       B  
+-------+-------+
| Region| Sales |
+-------+-------+
| South | 1500  |
+-------+-------+

After applying the bookmark, only the 'South' region data is visible.

Sheet Trace Quiz - 3 Questions

What does the bookmark save in Power BI?

A Only the visual colors

B The entire dataset

C The current filter state

D The report page layout only

Key Result

Bookmarks save and restore filter states to quickly switch views.