How to Use Sync Slicer in Power BI for Consistent Filtering

In Power BI, use the Sync slicer feature to apply the same slicer filter across multiple report pages. Select the slicer visual, go to the View tab, select Sync slicers, then choose which pages to sync and whether to show the slicer on those pages.

Syntax

The Sync Slicer feature in Power BI is accessed through the user interface rather than code. The main steps are:

• Select a slicer visual on your report page.
• Go to the View tab in the ribbon.
• Click Sync slicers pane to open it.
• In the pane, check the boxes for pages where you want the slicer to be synced.
• Choose whether to show or hide the slicer on each page.

This setup ensures the slicer selection applies across chosen pages.

power_bi

No code is required as Sync Slicer is a UI feature in Power BI Desktop.

Example

This example shows how to sync a slicer filtering by Region across two report pages.

1. Add a slicer visual on Page 1 with the Region field.
2. Go to the View tab and open Sync slicers pane.
3. Check the box for Page 2 to sync the slicer.
4. Choose to show the slicer on Page 2 or keep it hidden but synced.
5. Now, selecting a region on Page 1 filters data on both pages.

power_bi

/* No code needed, steps done in Power BI UI */

Output

Selecting 'West' region on Page 1 slicer filters visuals on both Page 1 and Page 2 to show only 'West' data.

Common Pitfalls

• Not opening the Sync slicers pane from the View tab, so syncing options are missed.
• Forgetting to check the pages where slicer syncing is needed.
• Confusing showing the slicer on a page with syncing it; you can sync without showing the slicer.
• Using slicers with different fields or data types on synced pages causes no effect.
• Sync slicers only work with slicers based on the same field across pages.

plaintext

/* Wrong: Syncing slicers with different fields */
// Page 1 slicer on 'Region'
// Page 2 slicer on 'Category'
// Sync slicers pane checked - no sync effect

/* Right: Use same field slicers */
// Both pages slicers on 'Region'
// Sync slicers pane checked - filters sync correctly

Quick Reference

Step	Action	Notes
1	Select slicer visual	Choose slicer on any report page
2	Open View tab	Find Sync slicers option
3	Open Sync slicers pane	Pane shows all report pages
4	Check pages to sync	Select pages to apply slicer filter
5	Choose show/hide slicer	Decide if slicer appears on synced pages
6	Test slicer filter	Verify filter applies across pages

Key Takeaways

Use the Sync slicers pane from the View tab to sync slicers across pages.

Ensure slicers use the same field to sync filters correctly.

You can sync slicers without showing them on all pages.

Check the pages you want to sync in the Sync slicers pane.

Sync slicers improve report usability by consistent filtering across pages.