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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Also, You may like the following Power BI tutorials:
- Power BI Calculated Column Example
- Power bi conditional column example
- How to split column in Power bi
- How to change data source in Power Bi
- Power BI Admin Portal
- Power BI Quick Insights
- Power BI Group By Examples
- Power bi shared dataset permissions management
- Scheduled Power BI report data refresh
- Power BI nan error (Not a number) while dividing by Zero
- Power BI report using People Picker Field
- Power BI Measure Sum and Subtract Example
- Power BI convert hours to minutes
- Power BI convert yyyymmdd to date
- Get Month Name from Month Number in Power BI
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.
I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site EnjoySharePoint.com