skip to content

In Power BI, what report state does a bookmark capture when you save it?

level: middleimportance: should knowfreq 45%

answer

  1. a saved set of knob positions, not results
  2. three groups you can tick or untick
  3. the Selection pane's show/hide is part of it
  4. scope can be the whole page or just what you picked
  5. consumers can save their own in the Service

basics

~20 s

A Power BI bookmark saves the page's current state — filter and slicer selections, cross-highlight selection, sort order, drill level, and which visuals are shown or hidden — so a button can restore it. It stores no data; visuals re-query the model when applied.

solid answer

~50 s

A bookmark records the state of a report page and replays it later. That state covers **data** (filter pane and slicer selections, cross-highlighting, sort order, drill level), **display** (visual visibility from the Selection pane, spotlight and focus mode) and **current page**. Each bookmark can be scoped to all visuals or only the visuals you had selected, and each of those three groups can be switched off, so one bookmark changes visibility without touching filters. Bookmarks are the mechanism behind most "app-like" reports: a button assigned a bookmark action swaps a chart for a table, resets slicers, or steps through a guided story. They save *state*, not results — applying one re-queries the model, so the numbers are current and row-level security still applies. In the Service, consumers can also save **personal bookmarks**, visible only to them, on a report they do not own.

code

text · 11 lines
text
-- Bookmark "Sales - table view"
Data          : OFF   <- slicer + filter state untouched
Display       : ON    <- visibility of chart/table + the two buttons
Current page  : OFF   <- no navigation
Scope         : Selected visuals (chart, table, btnChart, btnTable)

-- Bookmark "Reset page"
Data          : ON    <- default slicers, no cross-highlight, default sort
Display       : ON
Current page  : ON
Scope         : All visuals

go deeper

for a junior

Be able to say a bookmark saves the page's current filters, slicers and visual visibility so a button can bring that state back, and that it never stores the data itself.

for a middle

Explain the Data / Display / Current page groups and the all-versus-selected-visuals scope, and show how unticking Data is what makes a clean toggle button.

for a senior

Demonstrate the maintenance judgment: few, well-named, narrowly scoped bookmarks; update them after structural edits; and never treat visual visibility as a security boundary.

for a principal

Own the standard across a report estate — a house pattern for reset buttons and view toggles, and a clear line that access control lives in row-level security and workspace permissions, not the canvas.

## The mental model A bookmark is a snapshot of *how the page is configured*, not of what it showed. Think of it as a saved set of knob positions: which slicer values are picked, which visuals are visible, how a table is sorted, how far a chart is drilled. Applying the bookmark puts the knobs back and lets the visuals re-query the model. Nothing about the data is stored, which is why a bookmark taken last quarter shows this quarter's numbers when replayed today, and why it can never surface data a reader's security role forbids. ## What is captured, in three groups **Data** — filter state at report, page and visual level, slicer selections, the current cross-highlight selection, sort order on visuals, and drill level within a hierarchy. **Display** — visual visibility as set in the Selection pane, plus spotlight and focus-mode state. This is the group that makes toggle buttons possible. **Current page** — whether applying the bookmark also navigates to the page it was taken on. Each group can be turned off for an individual bookmark, and this is the single most useful thing to know about them. A bookmark with **Data** unticked swaps a chart for a table without stomping the reader's slicer selections — exactly what you want for a "show as table" toggle. A bookmark with everything ticked is a "reset the page" button. The **All visuals / Selected visuals** scope matters for the same reason. A bookmark scoped to selected visuals only touches the ones highlighted when you saved it, leaving the rest of the page alone. Broad-scoped toggle bookmarks are the usual cause of "my button also reset the date slicer". ## What is not captured The data itself, obviously. But also: changes to the *structure* of a report made after the bookmark was saved. Bookmarks store a description of a page as it stood, so adding a new visual or a new slicer later leaves existing bookmarks unaware of it, and they can behave oddly — the classic symptom is a new visual that ignores a bookmark, or a hidden visual that reappears. The remedy is to update every affected bookmark after structural edits, which is why teams keep the number of bookmarks in a report deliberately small. ## How bookmarks get used *Toggles.* Two bookmarks — chart visible with table hidden, and the reverse — each wired to a button with a bookmark action, with the buttons themselves included in the visibility state so the pair swaps too. *Reset.* One bookmark saved with the page in its default condition, wired to a "Reset filters" button. This is the cheapest usability win in a Power BI report and readers ask for it constantly. *Guided narrative.* A bookmark group played in order, each step filtering to a point in the story. *Layering.* Bookmarks combined with grouped visuals in the Selection pane let one page act as several — a summary layer and a detail layer stacked in the same canvas region. ## Personal bookmarks in the Service A consumer viewing a shared report can save their own bookmark of the state they care about — their region, their product line — and set it as their default view. Personal bookmarks live with that user and never alter the published report. They are worth mentioning because they answer the frequent request "can each manager have their own default filters" without forking the report or building per-user copies. They coexist with the Service's persisted-filter behaviour, which already remembers a user's last filter state on a report. ## Where candidates go wrong The two mistakes an interviewer listens for: believing a bookmark stores the data (it does not — it replays state and re-queries), and building a wall of bookmarks that becomes unmaintainable because every structural change requires revisiting all of them. A third, subtler one: using bookmarks as security. Hiding a visual with a bookmark hides pixels, not rows; anyone with access to the underlying semantic model can query what the visual would have shown. Security is row-level security in the model plus workspace and app permissions, never visibility on the canvas. ## Practical advice Name bookmarks for what they do ("Sales — table view", "Reset"), untick the groups you do not need, scope to selected visuals wherever possible, and keep a written note of which button points at which bookmark. Future-you, editing the report six months later, will not be able to infer it from the canvas.

  • How would you build a button that swaps a chart for a table without disturbing the reader's slicer selections?
    Save two bookmarks that differ only in visual visibility — chart shown with table hidden, and the reverse — and untick Data on both so they carry no filter state. Scope them to the visuals involved, include the buttons themselves in the visibility, and assign each bookmark to the opposite button's action.
  • Can bookmarks be used to hide sensitive visuals from certain readers?
    No. A hidden visual is hidden pixels; the underlying rows are still queryable by anyone with access to the semantic model, and any reader can apply a different bookmark or export data. Restricting what a person can see is row-level security in the model, plus workspace and app permissions.
  • Why do bookmarks sometimes misbehave after a report is edited?
    A bookmark stores a description of the page as it stood when saved. Adding, deleting or renaming visuals and slicers afterwards leaves that description stale, so a new visual may ignore the bookmark or a hidden one reappear. Update the affected bookmarks after structural edits, and keep their number small for that reason.

saying these in an interview costs you the question

  • Says a bookmark stores the data as it looked at save time
  • Thinks hiding visuals with a bookmark is a security control
  • Unaware that filter and display state can be captured separately
  • Believes bookmarks always apply to every visual on the page
  • Confuses a report bookmark with a browser bookmark of the report URL

context