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])

Practice

1. What is the main purpose of syncing slicers across pages in Power BI reports?

easy

A. To apply the same filter selection on multiple report pages automatically

B. To create new data columns based on slicer values

C. To change the color theme of all pages at once

D. To export slicer selections as a separate file

Solution

1. Step 1: Understand slicer syncing concept

   Syncing slicers means the filter choice you make on one page applies to other pages too.

2. Step 2: Identify the main benefit

   This saves time and keeps filter selections consistent across pages.

3. Final Answer:

   To apply the same filter selection on multiple report pages automatically -> Option A

4. Quick Check:

   Sync slicers = same filter on many pages [OK]

Hint: Sync slicers = one filter controls many pages [OK]

Common Mistakes:

• Thinking slicers create new data columns
• Confusing slicer sync with theme changes
• Assuming slicers export data

2. Which option correctly describes how to enable slicer syncing in Power BI Desktop?

easy

A. Right-click the slicer and select 'Sync slicers' from the context menu

B. Drag the slicer to the report header to sync automatically

C. Use the 'View' tab and open the 'Sync slicers' pane to select pages to sync

D. Enable slicer syncing in the 'Data' tab under 'Transform data'

Solution

1. Step 1: Locate slicer sync feature

   In Power BI Desktop, slicer syncing is managed via the 'Sync slicers' pane.

2. Step 2: Access the pane correctly

   You open it from the 'View' tab, then choose which pages to sync and show slicers on.

3. Final Answer:

   Use the 'View' tab and open the 'Sync slicers' pane to select pages to sync -> Option C

4. Quick Check:

   'View' tab > 'Sync slicers' pane = correct method [OK]

Hint: Sync slicers pane is in the View tab [OK]

Common Mistakes:

• Looking for sync option in slicer right-click menu
• Dragging slicers to headers does not sync
• Searching in Data tab instead of View tab

3. Given a report with three pages: Page1, Page2, and Page3. You sync a slicer on Page1 to Page2 only and hide it on Page2. What happens when you select a filter on Page1?

medium

A. The slicer becomes visible on Page2 but does not filter data

B. The filter applies on Page1 and Page2, but the slicer is visible only on Page1

C. The filter applies on all three pages automatically

D. The filter applies only on Page1; Page2 remains unfiltered

Solution

1. Step 1: Understand sync and visibility settings

   Syncing a slicer means filter selections apply to synced pages. Hiding slicer on a page means it filters but is not shown.

2. Step 2: Apply to given scenario

   The slicer on Page1 filters Page1 and Page2. On Page2, the slicer is hidden but filter applies.

3. Final Answer:

   The filter applies on Page1 and Page2, but the slicer is visible only on Page1 -> Option B

4. Quick Check:

   Sync + hide = filter applies, slicer hidden [OK]

Hint: Hidden slicer still filters synced pages [OK]

Common Mistakes:

• Assuming hidden slicer disables filtering
• Thinking filter applies to all pages automatically
• Confusing visibility with syncing

4. You synced slicers across pages but notice that changing a slicer on Page1 does not update Page3. What is the most likely cause?

medium

A. Page3 was not selected in the Sync slicers pane for that slicer

B. The slicer on Page1 is not connected to any data

C. Power BI does not support syncing slicers across more than two pages

D. The slicer on Page3 is set to 'Single select' mode

Solution

1. Step 1: Check sync pane page selection

   Sync slicers only work on pages selected in the Sync slicers pane for that slicer.

2. Step 2: Identify missing page

   If Page3 is not checked, it won't update when slicer changes on Page1.

3. Final Answer:

   Page3 was not selected in the Sync slicers pane for that slicer -> Option A

4. Quick Check:

   Page not selected in sync pane = no update [OK]

Hint: Always check sync pane page list for slicer [OK]

Common Mistakes:

• Assuming slicers sync automatically on all pages
• Blaming slicer data connection without checking sync
• Confusing slicer selection mode with syncing

5. You want to sync a slicer across four report pages but show the slicer only on two of them. How do you configure this in Power BI?

hard

A. Create separate slicers on each page and link them with bookmarks

B. Place the slicer on a report tooltip to share across pages

C. Use a measure to replicate slicer selections on hidden pages

D. In the Sync slicers pane, check all four pages for syncing, then uncheck 'Visible' for the two pages where slicer should be hidden

Solution

1. Step 1: Use Sync slicers pane to select pages

   Open the Sync slicers pane and check all pages where filter should apply.

2. Step 2: Control slicer visibility per page

   Uncheck the 'Visible' box on pages where slicer should be hidden but still filter data.

3. Final Answer:

   In the Sync slicers pane, check all four pages for syncing, then uncheck 'Visible' for the two pages where slicer should be hidden -> Option D

4. Quick Check:

   Sync all pages + hide slicer on some = correct setup [OK]

Hint: Sync all pages, toggle visibility per page in sync pane [OK]

Common Mistakes:

• Trying to sync slicers by bookmarks instead
• Using measures instead of slicer sync
• Misusing tooltips to share slicers