Sync slicers across pages in Power BI - Dashboard Guide

Dashboard Mode - Sync slicers across pages

Dashboard Goal

This dashboard answers: How can we keep the same filter selections on multiple report pages to analyze sales data consistently?

Sample Data

Order ID	Region	Product	Sales Amount	Order Date
1001	East	Chair	250	2024-01-15
1002	West	Table	450	2024-01-20
1003	East	Desk	300	2024-02-05
1004	North	Chair	150	2024-02-10
1005	South	Table	500	2024-03-01
1006	West	Desk	350	2024-03-15
1007	East	Chair	200	2024-03-20

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM('Sales'[Sales Amount])
  Shows the sum of sales filtered by slicers.
• Bar Chart: Sales by Region
  Visualizes total sales per region.
  Uses Region on axis and Total Sales measure.
• Table: Sales Details
  Shows Order ID, Product, Region, Sales Amount, and Order Date.
  Updates based on slicer selections.
• Slicer: Region Filter
  Allows selecting one or multiple regions.
  Set to sync across all report pages.
• Slicer: Product Filter
  Allows selecting one or multiple products.
  Also synced across all pages.

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |      Region Slicer    |
|    Total Sales       |                      |
+----------------------+----------------------+
|      Bar Chart       |     Product Slicer    |
|   Sales by Region    |                      |
+---------------------------------------------+
|               Sales Details Table             |
+---------------------------------------------+

Interactivity

The Region and Product slicers are synced across all report pages. When you select a region or product on one page, the selection automatically applies on other pages.

This means the Total Sales KPI, Sales by Region bar chart, and Sales Details table update together based on the slicer choices, no matter which page you are on.

This sync is set up in Power BI by selecting the slicer, opening the Sync Slicers pane, and enabling sync for all pages.

Self Check

If you add a filter selecting Region = East on the Region slicer on Page 1, which components update on Page 2?

• The Total Sales KPI card will show total sales only for East region.
• The Sales by Region bar chart will show bars filtered to East region data.
• The Sales Details table will list only orders from East region.
• The Region slicer on Page 2 will also show East selected, reflecting the sync.

Key Result

A sales dashboard with synced Region and Product slicers across pages updating KPIs, charts, and tables consistently.