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.