0
0
Power BIbi_tool~10 mins

Sync slicers across pages in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

Sample sales data by region used to demonstrate slicer filtering and syncing across report pages.

CellValue
A1Region
A2North
A3South
A4East
A5West
B1Sales
B21000
B31500
B41200
B51300
Formula Trace
Sync slicer selection on 'Region' across Page1 and Page2
Step 1: User selects 'South' in slicer on Page1
Step 2: Power BI syncs slicer selection to Page2 slicer
Step 3: Page2 visuals filter data where Region = 'South'
Cell Reference Map
    A       B
1 |Region | Sales
2 |North  | 1000
3 |South  | 1500
4 |East   | 1200
5 |West   | 1300

Slicer on 'Region' filters rows 2-5
Sync arrows: Page1 slicer -> Page2 slicer
The slicer filters the 'Region' column (A2:A5). The selection on Page1 is synced to Page2 slicer, which filters visuals using the same 'Region' column.
Result
South
South
Both pages show the slicer selection 'South'. Visuals on both pages update to show only data for the 'South' region, demonstrating synced slicers.
Sheet Trace Quiz - 3 Questions
Test your understanding
What happens when you select 'South' in the slicer on Page1?
AThe slicer on Page2 also selects 'South'.
BOnly Page1 visuals update; Page2 remains unchanged.
CPage2 slicer clears its selection.
DPage2 shows data for all regions.
Key Result
Sync slicers replicate user selection across report pages to filter visuals consistently.