Sync slicers across pages in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

How does syncing slicers across pages work in Power BI?

Imagine you have a report with multiple pages. You want a slicer on one page to control filters on other pages too. How does Power BI achieve this?

A By using the Sync slicers pane to select which slicers to sync across pages.

B By creating a slicer on each page and manually linking their filters in the data model.

C By copying the slicer visual and pasting it on other pages without any extra setup.

D By applying a global filter in the report settings that affects all slicers automatically.

💡 Hint

Look for a built-in feature that helps connect slicers across pages.

Power BI provides a Sync slicers pane where you can choose which slicers to sync across report pages. This allows slicers to share filter selections.

❓ dax_lod_result

intermediate

DAX measure behavior with synced slicers

You have a synced slicer filtering 'Product Category'. You create this measure:

Total Sales = SUM(Sales[Amount])

What will this measure show when you select 'Bikes' in the synced slicer on any page?

A Total sales amount for all products, ignoring the slicer selection.

B Total sales amount only for products in the 'Bikes' category, filtered by the slicer.

C Total sales amount for the last selected category before 'Bikes'.

D An error because the measure does not reference the slicer.

💡 Hint

Think about how slicers filter data and how measures respond.

The synced slicer filters the data model for 'Product Category' = 'Bikes'. The measure sums sales only for that filtered data.

❓ visualization

advanced

Design a report with synced slicers across three pages

You want to create a report with three pages: Sales Overview, Product Details, and Region Analysis. You want a slicer for 'Year' synced across all pages. Which setup is correct?

A Use a page-level filter for 'Year' on each page instead of slicers.

B Create separate slicers for 'Year' on each page without syncing them.

C Create a slicer for 'Year' on the Sales Overview page only, then enable sync for all pages in the Sync slicers pane.

D Create a slicer on the Region Analysis page and copy it to the other pages without syncing.

💡 Hint

Remember syncing requires slicers on each page and enabling sync.

To sync slicers, you place slicers on each page and use the Sync slicers pane to connect them. Creating only one slicer and syncing it to all pages works if slicers exist on those pages.

🔧 Formula Fix

advanced

Why does a synced slicer not filter on one page?

You synced a slicer for 'Region' across three pages. On two pages, the slicer filters data correctly. On the third page, the slicer selection does not filter visuals. What is the most likely cause?

A The slicer on the third page is not linked in the Sync slicers pane.

B The data model does not contain the 'Region' column.

C The visuals on the third page ignore filters by design.

D The slicer uses a different field than the visuals on the third page.

💡 Hint

Check if the slicer and visuals use the same field.

If the slicer filters a different field than the visuals use, the filter won't apply. The slicer and visuals must use the same column or related columns.

🎯 Scenario

expert

Implementing synced slicers with different filter directions

You have a data model with tables 'Sales', 'Products', and 'Regions'. You want a slicer on 'Regions[RegionName]' synced across pages. However, the 'Sales' table filters 'Products' but not 'Regions' directly. How do you ensure the slicer filters sales data correctly on all pages?

A Set the relationship between 'Regions' and 'Sales' to both directions to allow filtering from slicer to sales.

B Create a calculated column in 'Sales' to copy 'RegionName' and use that in the slicer.

C Use disconnected slicers and apply manual filter measures in visuals.

D Remove the relationship between 'Products' and 'Sales' to simplify filtering.

💡 Hint

Think about how filter directions affect slicer filtering across related tables.

Setting the relationship to both directions allows the slicer on 'Regions' to filter 'Sales' through 'Products'. This enables synced slicers to filter data correctly across pages.

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