How to use Power BI sync slicers

In this Microsoft Power BI Tutorial, We will discuss what is a Sync Slicers in Power BI, How to sync a slicer in the Slicer filter visualization.

Also, We will see how to use it on all pages in a Power BI report. By taking one simple example, I will explain to you that how you can use Power BI Sync Slicers.

Power BI Sync Slicers

In this example, I have a Product Sales data report details. This report has a total of two pages as:

  • Sales and
  • Sales By City

In the Power BI Report, the Sales Page looks like below screenshot.

Here I have added a Slicer filter under the Visualization section. As I wanted to see the report per yearly basis so that I have added the Year (Number data type) field to the Slicer filter as shown below.

slicer in power bi

This below screenshot represents my second page i.e. Sales By City. As per my requirement, I want to view the report per yearly basis where the slicer filter will effect other pages.

That means, Suppose I want to view the Product Sales report of 2017. For that, I have to select 2017. When I will select 2017, then it should effect all pages that have contained in the Power BI Report.

As I have two pages (Sales and Sales By City) in my Power BI Report, So when I will select one of the years from the Slicer, then the values should effect each page of that report and it will show me the exact value in all pages.

power bi slicer

In the Slicer filter Visualization, As there is no direct option to sync, so we have to enable the Sync Slicers option from the Power BI Desktop itself.

To enable the Power BI Sync Slicers option, Go to the View tab and check the Sync slicers option as shown below.

sync slicer in power bi desktop

Once you put the check mark in Sync slicers option, then you can see a Sync slicers pane which is present in between the Filters and Visualizations as like the below screenshot.

how to sync slicer in power bi

Now suppose you want to view the Product Sales details of 2015, then you have selected 2015 from the slicer filter. Once you will select any year from the filter, then the Sync slicers pane will appear on the right side of the page as shown below.

The Sync slicers pane has below fields as:

  • Page name: It helps to display all the pages that contained by the Power BI Report.
  • Sync: This option helps to sync the slicer and use it on any or all pages in a report.
  • Visible: If you will enable this option on any page, then you can view that specific filter on that existing page otherwise you won’t.

As in the below screenshot, I have selected both Sync and visible of the Sales page, So I can see the filter in only the Sales Page.

As I did not select the visible option of second page (Sales By City), So I will not see the filter in this page. It will only sync the values as I have selected only the Sync option as shown below.

how do you sync slicers in power bi

You can see the second page (Sales By City) in the below screenshot where the filter is not appearing. It has synced only and shows the below values depending upon the filter.

how to use sync slicer in power bi

Suppose you want to see the slicer filter in both of the pages, So simply you select any year and just check the Visible option in which page you want to view the filter.

use sync slicer in power bi

Once you will check the Visible option and go to that specific page, then you can see the slicer filter with exact values in that specific page as shown below.

sync slicer in power bi

Not only you can sync the slicer filter with the List values, but also you can sync with Dropdown, Between, Less than or equal to and Greater than or equal to option.

Here I have taken the slicer filter as Between and have taken the year range between 2017 to 2019. And I did the same process of Sync slicer as like previous one. I have selected both sync and visible option in all two pages.

power bi sync slicer

Now you can see the filter visual is appearing on the second page as I have checked the Visible option. Also, I am getting the Product Sales values within the range between 2017 to 2019.

power bi slicer panel

Also, You may like the following Power BI tutorials:

Hence in this Microsoft Power BI Tutorial, We discussed what is a Sync Slicers in Power BI, How to sync a slicer in the Slicer filter visualization.

Also, We saw how to use it on all pages in a Power BI report by taking one simple example.

>