How to Sync Slicers in Power BI on Same Page
Building an interactive dashboard in Power BI means giving users the power to filter and explore data with ease, and slicers are the perfect tool for the job. However, when you have multiple slicers on a single report page, you need them to work together seamlessly. This guide will walk you through exactly how to sync slicers in Power BI when they are on the same page, ensuring your reports are intuitive and consistent.
A Quick Refresher: What is a Slicer in Power BI?
Before we dive into syncing, let's quickly touch on what slicers are. Think of a slicer as a user-friendly filter right on your report canvas. Instead of tucking filters away in a side panel, slicers let users click buttons, use sliders, or select from a list to narrow down the data shown in the report's visuals. They can filter by date, product category, geographical region, or any other dimension in your dataset.
For example, instead of seeing sales data for all years, a user can click "2023" on a slicer to instantly see a report focused solely on that year's performance. They make static reports come alive, turning them into dynamic and interactive dashboards.
Why Sync Slicers on the Same Report Page?
You might wonder why you'd need more than one slicer for the same data field on a single page. It’s a common need for several good reasons, all centered on creating a better user experience.
- Consistent User Experience: If you have a large or complex report page, you might place the same slicer - for instance, a date filter - at both the top and the bottom. Syncing them means a user can change the date in either place, and both slicers (and all related visuals) will update instantly. No more scrolling up to change a filter and scrolling back down to see the results.
- Flexible Filtering Options: Syncing allows you to offer different types of slicers for the same data field. You could provide a simple dropdown slicer for "Region" for a clean look, but also a full list-view slicer for users who want to see every option at once and make multiple selections. When they are synced, a selection in one automatically reflects in the other.
- Intuitive Report Design: For dashboards divided into distinct sections, having local filter controls that are all in sync creates a more logical flow. A user can interact with the part of the dashboard they are focused on, confident that their filters are being applied consistently across the entire page.
In short, syncing slicers removes friction and makes your report feel smarter and more polished. It ensures that no matter where or how a user applies a filter, the entire report responds consistently.
Step-by-Step Guide to Syncing Slicers on the Same Page
Power BI has a dedicated feature for this called Sync slicers. It’s surprisingly simple to use once you know where to find it. Let's walk through the exact steps.
For this example, imagine we have a sales dashboard page with two visuals: a bar chart showing Sales by Product, and a table showing Sales by Country. We want to add two slicers for Product Category and have them mirror each other's selections.
Step 1: Add Your Initial Visuals and First Slicer
First, get your report page set up. Drag your visuals onto the canvas, then add your primary slicer.
- Click on a blank space on your report canvas.
- From the Visualizations pane, select the Slicer icon.
- From the Data pane, drag the field you want to filter by (e.g.,
Product Category) into the "Field" well of the slicer visual. - Format it as you see fit. Let's make this one a dropdown list by going to Format visual > Slicer settings > Options > Style > Dropdown.
At this point, you have one slicer that filters the visuals on your page.
Step 2: Add Your Second Slicer for the Same Field
Now, repeat the process to add your second slicer. It's crucial that you use the exact same data field.
- Click on another blank space on the canvas.
- Select the Slicer icon from the Visualizations pane again.
- Drag the same field (
Product Category) into the "Field" well. - Let's keep this one as the default list style (Vertical list) so we can easily tell them apart.
If you try using them now, you'll notice they work independently. Selecting "Clothing" in one does nothing to the other. Let's fix that.
Step 3: Open the Sync Slicers Pane
This is where the magic happens. The controls for syncing are located in a special pane that you need to enable.
- Navigate to the View tab in the Power BI ribbon at the top of the screen.
- In the "Show panes" section, find and check the box for Sync slicers.
A new Sync slicers pane will appear on the right side, typically next to the Visualizations and Data panes.
Step 4: Configure the Sync Behavior
The Sync slicers pane allows you to control which slicers are linked and what they affect across all pages of your report. As soon as you added the second slicer using the same field, Power BI was smart enough to automatically group them.
- Click on one of your
Product Categoryslicers to select it. - Look at the Sync slicers pane. You will see a table listing all the pages in your report.
- For the row corresponding to your current page, you’ll see two checkboxes: one under a "sync" icon (looks like a refresh arrow) and another under an "eye" icon (for visibility).
- To make the slicers mirror each other, check the box in the "Sync" column for the current page. Do this for both slicers within the group.
What do these columns mean?
- Sync (arrow icon): Checking this box means the slicer's selections will be mirrored by other slicers in the same group. When you filter one, the others update too. This is the key for syncing.
- Visible (eye icon): Checking this box controls whether the slicer's filter is applied to the visuals on that page. In almost all cases for on-page syncing, you'll want this checked.
Step 5: Test Your Synced Slicers
Now for the fun part. Go back to your report canvas and interact with your slicers.
- Select "Accessories" in your dropdown slicer. The list slicer should instantly highlight "Accessories" as well, and all visuals on the page will filter accordingly.
- Now, on the list slicer, uncheck "Accessories" and select "Bikes". The dropdown slicer's selection should immediately update to "Bikes".
That's it! Your slicers are now perfectly in sync on the same page.
Advanced Tips and Best Practices
Once you've mastered the basics, here are a few extra tips to take your slicer management to the next level.
Managing Slicer Groups
What if you want to sync a set of Date slicers and, completely separately, a set of Region slicers? Power BI groups slicers based on the field they use, but for clarity, you can give these groups a name.
In the Sync slicers pane, click on Advanced options. This will reveal the name of a slicer group (e.g., Field: 'Product'[Product Category]). You can double-click this name to rename it to something more descriptive, like "Product Category Filters." This is incredibly helpful in complex reports with many synced slicer groups.
Controlling Slicer Impact with 'Edit Interactions'
Sometimes you want your synced slicers to filter most visuals on the page, but not all of them. For example, maybe you want a KPI card to always show the company-wide total, regardless of the slicer selection.
This is controlled by Edit Interactions:
- Select one of your synced slicers.
- Go to the Format tab on the ribbon.
- Click Edit interactions.
- Tiny icons will appear on the top-right corner of every other visual. You have two main options:
- Click the None icon on any visual you want the slicer to ignore.
Troubleshooting Common Issues
If your slicers aren't syncing as expected, run through this quick checklist:
- Are they using the exact same field? Ensure both slicers are pulling from the same table and column in your data model. Don't use
Table1[Category]for one andTable2[Category]for the other, even if the data is identical. - Are they in the same group? Check the Sync slicers pane. If they appear in different groups, they won't sync together.
- Is the 'Sync' box checked? This is the most common miss. Double-check that the "sync" icon column is checked for your page.
Final Thoughts
Mastering the "Sync slicers" feature greatly improves the professionalism and usability of your Power BI reports. By ensuring your filters are consistent and intuitive, you empower users to explore their data confidently without needing to fight with the dashboard.
Ultimately, the goal is always to get answers from your data with as little friction as possible. At Graphed, we created our entire platform around that idea. We remove the steep learning curves of tools like Power BI and the manual work of exporting data into spreadsheets. Instead, you can simply connect your data sources—like Shopify, Google Analytics, or Salesforce—and use plain English to ask for the dashboards and reports you need, getting live, interactive visuals in seconds.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.