Slicers and Sync Slicers
Slicers are interactive visual controls that allow report users to filter data directly on the report canvas. Instead of opening the filter pane, users can select a year, region, product, category, or another field and immediately explore the relevant information.
Learning Objectives
- Understand slicers and their purpose in a Power BI report.
- Create slicers using categorical and date fields.
- Configure list, dropdown, and date slicers.
- Control which visuals respond to a slicer.
- Synchronize slicers across multiple report pages.
1. What Is a Slicer?
A slicer is a visual filter placed directly on a report page. It gives users a simple way to select values and filter connected report visuals. Slicers are especially useful when reports are designed for interactive business analysis.
How a Slicer Works
Selecting a region filters the connected chart and other affected visuals to show information for that selection.
2. Create Your First Slicer
Assume a sales table contains the columns OrderDate,
Region, Product, and SalesAmount.
You can create a slicer that allows users to select a region.
Steps to Create a Region Slicer
- Open your report in Power BI Desktop.
- Select an empty area of the report canvas.
- Choose the Slicer visual from the Visualizations pane.
- Drag the
Regionfield into the slicer's field well. - Resize and position the slicer on the report page.
- Select a region and observe how connected visuals respond.
3. Common Slicer Types
| Slicer Type | Purpose | Example |
|---|---|---|
| List | Displays values in a visible list. | North, South, East, West |
| Dropdown | Saves report space by showing values in a compact menu. | Choose a product category. |
| Date or range slicer | Allows selection of dates or a date interval. | Orders between January and March. |
| Numeric range slicer | Filters numeric values within a range. | Sales amounts from 1,000 to 5,000. |
| Hierarchy slicer | Allows users to navigate related levels when supported by the visual and field setup. | Year, quarter, and month. |
List and Dropdown Examples
List slicers make options visible, while dropdown slicers are useful when report space is limited or the field contains many values.
4. Single Selection and Multiple Selection
Slicer selection settings determine whether users can choose one value or several values at a time. Available options depend on the slicer type and the Power BI version.
| Selection Mode | Behavior | Suitable Use |
|---|---|---|
| Single selection | Allows one value to be selected at a time. | Select one reporting year. |
| Multiple selection | Allows several values to be selected. | Compare multiple regions. |
| Select all | Provides an option to include all available values. | Return to an overall view. |
Selection Behavior
5. Format a Slicer
Formatting helps users understand how to interact with a slicer. Depending on the visual and current Power BI interface, formatting options may include the title, header, values, selection controls, background, border, and layout.
Recommended Formatting Steps
- Select the slicer on the report canvas.
- Open the Format visual pane.
- Enable and edit the title where appropriate.
- Adjust text size and spacing for readability.
- Use a consistent background and border style.
- Test the slicer at normal report viewing size.
6. Control Which Visuals a Slicer Affects
By default, a slicer generally filters other visuals on the same page that are connected to the selected data. You can customize its interactions when some visuals should remain unchanged.
Use Edit Interactions
- Select the slicer that will control the report.
- Open the Format ribbon and choose Edit interactions.
- Review the interaction controls shown on other visuals.
- Choose the appropriate filter, highlight, or no-interaction option where available.
- Exit Edit interactions and test the report.
Interaction Concept
A report designer can allow a slicer to filter the sales chart while preventing it from affecting a separate visual, such as a logo or an intentionally fixed reference indicator.
7. What Are Sync Slicers?
Sync slicers allow a slicer selection to be shared across multiple report pages. This is useful when users move between pages but need the same region, year, or category selection to remain active.
For example, a report may have a Sales Overview page, a Product Analysis page, and a Regional Performance page. A synchronized Region slicer can keep the selected region consistent as users navigate between these pages.
How Slicer Synchronization Works
8. Synchronize a Slicer Across Pages
Step-by-Step Instructions
- Create a slicer on the report page where it will first be used.
- Select the slicer.
- Open the View ribbon and choose Sync slicers.
- Review the pages listed in the Sync slicers pane.
- Enable synchronization for the pages that should share the selection.
- Use the visibility controls to decide where the slicer itself should appear, where available.
- Test the selection by switching between report pages.
9. Practical Business Example
Consider a sales report used by management at CIIT TRANING INSTITUTE. The report contains sales totals, product performance, and regional results. The goal is to allow users to filter these pages by year and region without repeatedly making the same selections.
| Report Page | Visuals | Slicer Configuration |
|---|---|---|
| Sales Overview | Total Sales card and monthly sales chart | Year and Region slicers |
| Product Analysis | Product sales chart and category table | Sync Year and Region selections |
| Regional Performance | Regional comparison chart | Sync Year and Region selections |
10. Common Slicer Problems
| Problem | Possible Cause | What to Check |
|---|---|---|
| A visual does not change | The interaction is disabled or the data model does not support the expected filtering. | Review Edit interactions, relationships, and field usage. |
| A selection does not appear on another page | The slicer is not synchronized with that page. | Review the Sync slicers pane. |
| The slicer uses too much space | A long list is displayed directly on the canvas. | Consider a dropdown slicer or a more compact layout. |
| Users cannot easily clear a selection | The reset or clear-selection behavior is not obvious. | Check available slicer controls and provide clear report instructions. |
| The report opens with an unexpected selection | A saved report state or bookmark may preserve a previous selection. | Review the saved report state and relevant bookmarks. |
11. Hands-On Practice
Practice Task 1: Create a Region Slicer
- Open a sales report containing a Region field.
- Add a slicer and place Region in its field well.
- Choose North and observe the changes in your charts.
- Choose another region and compare the results.
Practice Task 2: Create a Year Slicer
- Add a slicer using the appropriate year field from your date data.
- Configure its appearance to fit the report page.
- Select one year and compare the sales totals.
- Clear the selection and verify that the overall view returns.
Practice Task 3: Sync Slicers
- Create a second report page called Product Analysis.
- Open the Sync slicers pane.
- Synchronize the Region slicer across both pages.
- Change the region on one page and check the other page.
- Test whether the slicer should be visible on both pages.
12. Knowledge Check
Question 1: What is the main purpose of a slicer?
A. To write DAX formulas
B. To let users filter report data interactively
C. To create a database table
D. To publish a report automatically
Question 2: Which slicer style is useful when you need to save space?
A. Dropdown
B. A large list with every value visible
C. A text box with no field
D. A report title
Question 3: What is the purpose of Sync slicers?
A. To synchronize selections across selected report pages
B. To merge two tables
C. To change the data type of a column
D. To create a calculated column
Question 4: Where can you review which pages share a slicer selection?
A. The Sync slicers pane
B. The DAX formula bar
C. The database connection dialog only
D. The Windows desktop
Show Answers
- B — Slicers let users filter report data interactively.
- A — Dropdown slicers use less visible canvas space.
- A — Sync slicers share selections across configured report pages.
- A — The Sync slicers pane controls page synchronization and visibility.
Summary
Slicers make Power BI reports interactive by allowing users to filter data directly on the report canvas. They can display lists, dropdowns, date ranges, and other supported selection controls.
- Create slicers by adding a field to a Slicer visual.
- Choose suitable selection and formatting options for your audience.
- Use Edit interactions to control how a slicer affects other visuals.
- Use Sync slicers to share selections across selected report pages.
- Test slicer behavior and saved selections before publishing a report.
In the next lesson, you will learn how to use drill-down and drill-through features to explore data at different levels of detail.