Sync slicers across pages in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a business analyst at a retail company.

📋 Request: Your manager wants a report where selecting a filter on one page automatically applies the same filter on other report pages.

📊 Data: You have sales data with columns: Date, Region, Product Category, Sales Amount.

🎯 Deliverable: Create a Power BI report with at least two pages and slicers for Region and Product Category that stay synced across pages.

Sample Data

Date	Region	Product Category	Sales Amount
2024-01-01	North	Electronics	1000
2024-01-02	South	Clothing	1500
2024-01-03	East	Electronics	1200
2024-01-04	West	Furniture	800
2024-01-05	North	Clothing	700
2024-01-06	South	Furniture	900
2024-01-07	East	Clothing	1100
2024-01-08	West	Electronics	1300

1

Step 1: Load the sales data into Power BI Desktop.

Use 'Get Data' > 'Excel/CSV' or paste data manually.

Expected Result

Sales data table appears in Power BI Fields pane.

2

Step 2: Create two report pages named 'Page 1' and 'Page 2'.

Click '+' icon at bottom to add pages and rename them.

Expected Result

Two pages visible in report view.

3

Step 3: On Page 1, add slicers for 'Region' and 'Product Category'.

Insert > Slicer, then drag 'Region' field to first slicer and 'Product Category' to second slicer.

Expected Result

Two slicers appear on Page 1 filtering by Region and Product Category.

4

Step 4: On Page 2, add slicers for 'Region' and 'Product Category' as well.

Repeat slicer insertion and field assignment on Page 2.

Expected Result

Two slicers appear on Page 2 for Region and Product Category.

5

Step 5: Open the 'Sync slicers' pane from the View tab.

Click View > Sync slicers to open the pane on the right.

Expected Result

Sync slicers pane is visible.

6

Step 6: Select the Region slicer on Page 1 and in the Sync slicers pane, check boxes to sync it to Page 2 and make it visible there.

In Sync slicers pane, check 'Sync' and 'Visible' for Page 2 under Region slicer.

Expected Result

Region slicer is synced and visible on both pages.

7

Step 7: Repeat the sync setup for the Product Category slicer between Page 1 and Page 2.

Select Product Category slicer on Page 1, check 'Sync' and 'Visible' for Page 2 in Sync slicers pane.

Expected Result

Product Category slicer is synced and visible on both pages.

8

Step 8: Test the sync by selecting a Region and Product Category on Page 1, then navigate to Page 2.

Click a Region and Product Category in slicers on Page 1, then click Page 2 tab.

Expected Result

Page 2 slicers show the same selections automatically.

9

Step 9: Add visuals like bar charts on both pages to show Sales Amount by Region and Product Category.

Insert > Bar chart, drag 'Region' or 'Product Category' to Axis, 'Sales Amount' to Values.

Expected Result

Charts update based on synced slicer selections.

Final Result

Region Slicer

↓

Region Slicer

✓Syncing slicers improves user experience by keeping filters consistent across report pages.

✓Users can analyze sales data seamlessly without resetting filters on each page.

✓This technique saves time and reduces errors in multi-page reports.

Bonus Challenge

Add a third page with a date slicer synced to the other pages and create a measure showing total sales filtered by all slicers.

Show Hint

Use the Sync slicers pane to sync the date slicer across pages. Create a DAX measure: Total Sales = SUM('Sales'[Sales Amount])