How to Sync Slicers in Power BI?

Do you know how to sync slicers in Power BI? OK, no problem!

In this tutorial, I will explain a Power BI sync slicer and how to create a sync slicer in Power BI and Power BI sync date slicers with various examples.

Also, I will explain how to sync a slicer across multiple pages in Power BI Desktop.

Sync Slicers in Power BI

A Sync Slicer is like a teamwork tool in Power BI. It enables you to link several slicers in various sections of your report so that, upon selecting one, the remaining slicers will instantly adopt the same value. To put it another way, they act similarly.

For example:

In Power BI, We have two same slicers (Segment) and two same tables. When I select a value (Consumer) from one slicer, the other slicer automatically selects Consumer.

Similarly, when a user selects any value from the Power BI slicer, all the visuals [on the same page] will filter accordingly as per the user selection.

How to Sync Slicers in Power BI

This SharePoint list is connected to the Power BI desktop. You can see the Sharepoint list screenshot below.

ColumnsData Types
SegmentSingle line of text
CountrySingle line of text
ProductSingle line of text
Units SoldNumber
Manufacturing PriceNumber
Sale PriceCurrency
ProfitCurrency
SalesCurrency
Power bi sync slicers pane

How to Sync Slicers in Power BI

Now, I will tell you how to create a sync slicer in Power BI in simple steps:

1. Open Power BI Desktop and load data using the Get data options, then the data set shows in the Data panel.

Power bi sync slicers

2. I want to create two slicers with the same value here. To do this, under the Visualization panel, click on Slicer and then drag Country into the Slicer. Again, make a duplicate slicer using ctrl+c and ctrl+v on the same page.

how to sync slicers in power bi on same page

3. Select the View tab and click Sync slicers.

Enable the Sync Slicers feature in Power BI

4. In the middle of the Visualizations and Filter panels, the Sync slicer pane gets created in the Power BI Desktop.

Sync Two different slicers in power bi

5. When you select a slicer, you can see some properties and advanced options on the right side of the Sync slicer panel. Check in the screenshot below.

power bi sync slicer visuals

6. Next, check the sync option for the Page 1. Then you can see the Advanced options automatically take the group name as Country.

How to Sync Two Slicers on the Same Page in Power BI

7. Then select another slicer -> check the Sync option. In the Advanced options, automatically take the group name as Country 1, then give the group name as Country.

Microsoft power bi sync slicers advanced options

8. Once you sync the slicers, select the data from the slicer, and you will see another slicer automatically select this same data. In my case, I am selecting France; then another slicer automatically selects France.

Create a Sync Slicer in Power BI

In this way, we can Sync Slicers in Power BI.

How to Sync a Slicer Across Multiple Pages in Power BI

Here, I will tell you how to sync a slicer across multiple pages in Power BI.

I have a Sharepoint list (Supermart) with Order Date, Customer Name, Segment, State, Product Name, Sales, Profit, and Quantity(with different data types). Check out the screenshot below.

ColumnsData Types
Order DateDate and time
Customer NameSingle line of text
SegmentSingle line of text
StateSingle line of text
Product Name Single line of text
SalesCurrency
ProfitCurrency
QuantityNumber
Power bi sync slicers across pages


Using this SharePoint List, I have created two Power BI reports, namely Page 1 and Page 2.

Page 1 contains a column chart, a slicer, a pie chart, a donut chart, and a table visual. Check the screenshot below.

power bi apply slicer to all page visuals

Page 2 consists of the same slicer, one map, one table visual, and one bar chart. Check the screenshot below.

power bi sync visuals across pages

In this scenario, we must sync slicers, enabling more effective analysis. This means that when you filter using one slicer, Pages 1 and 2 will be filtered accordingly.

Now I will tell you how to achieve our requirements in simple steps.

1. Now, I hope you created a two-page report.

Microsoft power bi sync slicers on different pages

2. Select the Slicer (Order Date) -> View tab -> click Sync Slicers.

power bi sync multiple slicers

3. In the Sync slicer panel, under the sync icon, check the box, expand the Advanced option, and provide the group name. In my case, I am given the name Order Date.

sync multiple slicers in power bi

4. Now, our sync slicers across multiple pages are completed. To check this, you can filter the pages in the report, so, in my case, I selected 12/05/2016 in the Page 1 Slicer.

sync multiple slicers power bi

5. Page 2 automatically filtered. Check in the screenshot below.

How to Sync a Slicer Across Multiple Pages in Power BI

In this process, you can sync a slicer across multiple pages in Power BI.

Conclusion

I hope you found this tutorial enjoyable. In this tutorial, I explained what a sync slicer is, how to create a sync slicer, and how to synchronize a slicer across multiple pages in Power BI.

Also, you may like some more Power BI tutorials: