Power BI Lesson 13 – Page Navigation | Dataplexa

Beginner Level · Lesson 13

Page Navigation

A multi-page report with no navigation is a report that viewers do not know how to use. This lesson covers how to build buttons that move between pages, how to sync slicers so selections carry across pages, how to use bookmarks to save and restore states, and how to make a Power BI report feel like a proper application rather than a collection of disconnected tabs.

Why Page Navigation Matters

When you publish a report to Power BI Service, most viewers never notice the page tabs at the bottom — they are small and easy to miss. Even in Desktop, navigating by clicking tabs feels clunky for a polished report. Professional Power BI reports use visible navigation buttons, a consistent top-bar or side-bar menu, and sometimes hidden pages accessible only through drill-through actions. Building these controls takes fifteen minutes and completely transforms how a report feels to use.

Report without navigation

Viewers hunt for page tabs at the bottom. No visual cue of which page they are on. Moving between pages loses any slicer context. Feels like a raw data dump, not a business tool.

Report with navigation

Clearly visible buttons with active-page highlighting. Slicer selections carry across pages. Viewers know exactly where they are. Feels like a product — not a spreadsheet. Increases report adoption significantly.

Method 1 — Page Navigation Buttons

The fastest way to build navigation is with Power BI's built-in Page Navigator button. This is a single object that automatically creates one button per page and highlights the current page — with no manual configuration needed.

Insert → Buttons → Navigator → Page Navigator Go to the Insert tab in the ribbon, click Buttons, then hover over Navigator and click Page Navigator. A horizontal row of buttons appears — one per visible page — already labelled with your page names.

Place on every page in the same position Copy the Page Navigator (Ctrl+C), then navigate to each other page and paste it (Ctrl+V) in the exact same position — usually a strip at the top or left side of the canvas. Use Format → Align → Align Top and set X/Y position manually via the Format pane to ensure pixel-perfect placement across all pages.

Test in reading mode Ctrl+click any navigation button in Desktop to test it (single-click only works in published Service view or reading mode). The active page button highlights automatically — no additional formatting needed.

Report with Page Navigator — Overview page active

Sales Report 2024

Overview

Regional Detail

Products

Customer Analysis

Overview page content — KPI cards, bar charts, slicers

Method 2 — Manual Navigation Buttons

For full control over button appearance — custom icons, colours, hover states, and exact text — you build individual buttons manually and assign a page navigation action to each one. This takes more setup but gives you complete design flexibility.

Insert → Buttons → Blank Insert a blank button onto the canvas. In the Format pane, set the button text, font size, background colour, and border. Create one button for each destination page.

Assign a Page Navigation action With the button selected, open the Format pane → Button → Action. Toggle Action to On. Set the Type to Page navigation. In the Destination dropdown, choose the page this button should navigate to.

Style the active state differently on each page Since manual buttons do not auto-highlight, copy the button set to each page and manually change the fill colour of the button matching the current page to the "active" style — for example, filled blue vs outlined grey.

Format pane — Button Action configuration

Format button

Style

Shape

Action ← expand this

Alt Text

Action

Type

Page navigation▾

Destination

Regional Detail▾

Ctrl+click to test navigation in Desktop · Single click works in Service

Syncing Slicers Across Pages

By default, slicers only filter the page they live on. If a viewer selects "2024" on the Overview page and moves to Regional Detail, the year selection is lost. Slicer sync fixes this — it lets you choose exactly which pages share a slicer's selection.

Select the slicer you want to sync Click the slicer on your page — for example, a Year slicer or Region slicer on the Overview page.

View → Sync Slicers Go to View → Sync Slicers in the ribbon. A panel opens on the right showing every page in your report. Two columns appear next to each page name.

Configure sync and visibility per page Each page has two checkboxes — Sync and Visible. Sync means that page receives and shares the slicer selection. Visible means the slicer is physically shown on that page. You can sync without showing — the slicer filters the page silently in the background.

Sync Slicers panel — Year slicer selected

Slicer: Year (OrderDate)

Page

Sync

Visible

Overview

Regional Detail

Products

Customer Analysis

Sync + Visible = slicer appears and is connected on that page

Sync only = slicer is hidden but still filters that page

Neither = page is completely unaffected by this slicer

Bookmarks

A bookmark is a snapshot of the current state of a report page — which visuals are visible, which filters are applied, which slicer values are selected. You can capture any state as a bookmark and then assign buttons to jump directly to that state. Bookmarks are what power toggle buttons, reset buttons, show/hide panels, and guided story views in advanced reports.

Bookmark use case	What it does	How it works
Reset button	Clears all slicer selections and returns the page to its default state	Capture a bookmark with all slicers cleared. Assign that bookmark to a "Reset" button action.
Show/hide panel	A "Filter" button slides a slicer panel in and out of view	Two bookmarks — one with the panel visible, one hidden. Two buttons each assigned to the opposite bookmark.
Story navigation	Next/Back buttons walk viewers through a pre-set sequence of insights	Each "slide" is a bookmark with specific filters applied. Buttons navigate the bookmark sequence in order.
Chart toggle	Switch between a bar chart view and a table view of the same data	Two bookmarks — one with bar chart visible and table hidden, one the opposite. A toggle button switches between them.

Creating and Using Bookmarks

CREATING A BOOKMARK:

1. Set up the page exactly as you want it captured
   (apply the slicer values, show/hide visuals, set filters)

2. View → Bookmarks panel (opens on the right)

3. Click "Add" in the Bookmarks panel
   Power BI captures the full current state of the page
   Rename the bookmark something descriptive:
   "Default View", "2024 Only", "Panel Hidden", etc.

4. Repeat for each state you want to capture

─────────────────────────────────────────────────

ASSIGNING A BOOKMARK TO A BUTTON:

1. Insert → Buttons → Blank (or any button type)

2. Format pane → Button → Action → On
   Type: Bookmark
   Bookmark: select from dropdown (e.g. "Default View")

3. Ctrl+click the button in Desktop to test it
   The page snaps to the saved state instantly

─────────────────────────────────────────────────

BOOKMARK PROPERTIES — control what gets captured:

Right-click a bookmark in the Bookmarks panel:
  ☑ Data     — captures slicer selections and filters
  ☑ Display  — captures which visuals are visible/hidden
  ☑ Current page — captures the page itself

Uncheck "Data" to make a bookmark that only
shows/hides visuals without resetting slicer values

Building a Reset + Show/Hide Filter Panel using bookmarks

Step 1 — Create "Default View" bookmark

Clear all slicers → open Bookmarks panel → Add → rename "Default View"

Step 2 — Create "Panel Visible" bookmark

Make filter panel visible on canvas → Add → rename "Panel Visible"

Step 3 — Create "Panel Hidden" bookmark

Hide filter panel (Selection pane → click eye icon) → Add → rename "Panel Hidden"
Right-click "Panel Hidden" → uncheck Data (so slicer values are not reset when hiding panel)

Step 4 — Wire up buttons

"Reset filters" button → Action → Bookmark → "Default View"
"Show filters" button → Action → Bookmark → "Panel Visible"
"Hide filters" button → Action → Bookmark → "Panel Hidden"

Result: professional-feeling report with working reset and slide-in filter panel — no coding required

Drill-Through Pages

A drill-through page is a hidden detail page that a viewer reaches by right-clicking a data point in a visual and choosing "Drill through." The drill-through page automatically receives the context of the clicked item — for example, right-clicking "Alice Brown" in a chart takes you to a page showing only Alice's orders. This is the standard Power BI pattern for moving from summary to detail.

Create a new page for the detail view Add a new page named something like "Customer Detail". Build all the visuals you want to show for a single customer — order history table, revenue trend, top products, etc.

Add a Drill-through field In the Visualizations panel's field wells, you will see a section labelled Drill through at the bottom. Drag the field that defines the drill-through context into it — for a customer detail page, drag CustomerName from the Customers table.

Hide the drill-through page Right-click the page tab and choose Hide Page. It still works as a drill-through destination — viewers reach it by right-clicking a customer in any visual — but it does not appear as a visible tab or in the Page Navigator.

Use it — right-click any customer name in any visual On any other page, right-click a customer name in a chart or table. A context menu appears with Drill through → Customer Detail. Clicking it navigates to the Customer Detail page already filtered to that specific customer. A back button appears automatically at the top-left of the drill-through page.

Drill-through context menu and destination page

Right-click "Alice Brown" in overview table

Alice Brown

Copy

Spotlight

Drill through ▶

Customer Detail

Customer Detail page — auto-filtered to Alice Brown

← Back

Alice Brown — Customer Detail

TOTAL SPEND

$3,850

ORDERS

All visuals on this page show Alice Brown's data only

Teacher's Note: The single most impactful upgrade you can make to any basic report is adding a Page Navigator and slicer sync. It takes ten minutes and immediately makes the report feel intentional rather than accidental. Do this before you spend time on visual formatting — navigation is the first thing every viewer interacts with, and a report that is confusing to navigate gets abandoned no matter how good the charts are.

Practice

Practice 1 of 3

To insert a set of navigation buttons that automatically creates one button per page and highlights the current page, you go to Insert → Buttons → Navigator → Page ___.

Practice 2 of 3

In the Sync Slicers panel, enabling the ___ checkbox for a page means the slicer filters that page silently even though the slicer is not physically visible on that page.

Practice 3 of 3

A hidden detail page that viewers reach by right-clicking a data point in a visual and choosing a destination from a context menu is called a drill-___ page.

Lesson Quiz

Quiz 1 of 3

A viewer selects "2024" in a Year slicer on the Overview page, navigates to the Products page, and the year selection is gone. What is the correct fix?

Copy the Year slicer onto the Products page so it resets to 2024 automatically on page load Select the Year slicer → View → Sync Slicers → enable the Sync checkbox for the Products page Add a report-level filter for Year = 2024 in the Filters pane Set the slicer to single-select mode — multi-select slicers do not carry values across pages

Quiz 2 of 3

You want a "Reset filters" button that clears all slicer selections and returns the page to its default state. What is the correct approach using bookmarks?

Set the button Action type to "Page navigation" pointing to the same page — navigating to a page resets its slicers automatically Write a DAX measure that detects the button click and clears filter context using REMOVEFILTERS() Clear all slicers manually, capture that state as a bookmark named "Default View", then assign that bookmark to the reset button's Action Set the button Action to "Back" — the Back button always returns to the unfiltered state

Quiz 3 of 3

You build a Customer Detail drill-through page and drag CustomerName into the Drill through field well. You test it but the "Drill through" option does not appear in the right-click context menu on the Overview page. What is the most likely cause?

The visual you right-clicked does not contain the CustomerName field — drill-through only appears when the clicked visual includes the drill-through key field The drill-through page is hidden — you must make it visible before the drill-through menu option appears Drill-through only works in Power BI Service — it is not available in Desktop You need to add a back button to the drill-through page before the drill-through menu option activates on other pages

Next up — Lesson 14 covers Visualization Basics — the principles behind choosing the right chart type, how to format visuals consistently, and the core visual types every Power BI user needs to know before moving into advanced charts.

← Previous Course Index Next →

Power BI Course