What is a Power BI Slicer?

A Power BI slicer is a canvas visual filter available in Power BI Desktop. Slicers in Power BI play the most crucial role in creating comparative charts or separate reports. They act as an alternative solution in filtering the narrow portions of datasets that are represented in the form of other visualizations in a particular report.

When to use a Slicer?

  • In order to display important or commonly-used filters on the report canvas for easier access.
  • In case you want to filter by columns to eliminate the hidden or unnecessary data in the tables.
  • To design more creative reports by placing slicers next to important visuals.
  • In finding easier ways to watch the currently filtered state without opening a drop-down list.

 

Do you want to become a Data Visualization expert? Then visit here to learn Power BI Course

How to create a new Slicer?

To create Slicers in Power BI one must go through the following steps, and they are:

Create a New Slicer

Step 1: Drag or select the data field first to create a visualization.

Step 2: Now, select the slicer icon present in the visualization pane to turn the visualization into a slicer.

Vizualization into a Slicer

Types of Power BI Slicers

The types of slicers in Power BI are listed below:

1. Relative Date Slicer

The date is the most important element at the time of business analysis because it helps us to identify the future forecast that how we are going to generate the revenue in the upcoming years.

There are four types of Power BI data slicers and they are:

  • Between
  • Before
  • After
  • List

Between 

In the Date Slicer "Between" provides the range of dates between the start and end date.

Between

Before

When we select the Before option in the Date Slicer, the start date automatically grades out, which means we can get the report before the end date.

Before

After

Subscribe to our youtube channel to get new updates..!

When we click on the “After” in the date slicer pane the end date becomes stagnant so that we can fetch the results after the start date.

After

List 

List in the Date Slicer provides a list of all the date ranges so that we can select dates accordingly for the results.

list

2. Numeric Range Slicer

The Numeric range slicer in Power BI is mainly used to apply all kinds of filter sorts to any numeric column in the data model. It even provides the most effective way to filter the data between numbers. 

Steps to create a new slicer to filter data by District Manager:

Step 1: In Power BI service or Power BI desktop, open the Retail Analysis Sample. 

Step 2: Select the slicer icon present in the visualization pane to create a new slicer.

Step 3: Next, select the District>DM from the pane of fields to populate the slicer. 

Step 4: New slicer is created with a list of names having selection boxes before them.

 District Manager

Step 5: Drag and resize the elements present on the canvas to make room for the slicer. 

Step 6: Select the names that are present on the slicer and make a note of the effects on the other visualizations on the page. Selecting all the names will have the same effect and impact as selecting none.

Frequently Asked Power BI Interview Questions

Formatting a Slicer

To format your slicer, select the format icon and it displays all the formatting control options. 

Formatting a Slicer

In the below example, the slicer that is present first has been converted to a dropdown in order to consume less space and then the option Select all has been added whereas the second slicer has been formatted with colors, font sizes, and allows only a single selection.

Procedure for creating a slicer to filter data by date range

Step 1: Firstly, without selecting anything on the canvas, just drop down the Store element from the pane of fields and then drag the OpenDate option to the values which are present in the visualization pane in order to create an effective visualization.

Step 2: Select the slicer icon to convert the new visualization to a slicer. 

Step 3: Drag and resize the elements present on the canvas and the slicer to make room size space for the slicer. Just note that the slider always resizes with the slicer size. 

Step 4: Using slider select different data ranges and keep an eye on effects on the other visualizations on the page.

Step 5: To change the slicer type, choose any one of the options from the box that you hover over the upper-right area of the slicer and make a note of the changes in slicer appearance.

Steps to Convert Vertical Slicer to a Horizontal Slicer

Step 1: With the selection of slicer, in the Visualization pane, now select the Format tab.

Step 2: Click on the General section for orientation and then select the horizontal option in it.

Step 3: If you want to extend for more values, probably make the pane wider.

Step 4: Right under the orientation in the general section of the Format tab, slide responsive (preview) to on.

How can you sync slicers in Power BI and use them on other pages?

Step 1: Select the Sync slicers checkbox present in the view menu on Power BI Desktop.

Step 2: The pane of Sync slicers is present in between the Visualizations pane and Filters.

Step 3: Select District Manager slicer present on the District Monthly Sales page.

Step 4: Now, select the Overview page and the page of New Stores present in the Sync column in order to make sure that the District Monthly Sales slicer directly syncs to those particular pages.

Step 5: Next, select both Overview and New Stores pages in the Visible column. The below image shows the representation of the Sync Slicer.

Step 6: In this step, the District Manager slicer present on the District Monthly Sales page shows the same selections as the one on the Overview page. On the page of New Stores, selections available in the Store Name Slicer are affected by the selections present in the District Manager slicer.

Power BI Slicers’ Limitations

  • Slicers in Power BI doesn't support visual level filters.
  • Input fields are not supported in Power BI Slicers.
  • Slicers do not support Drilldown.
  • Slicers in Power BI cannot be pinned to a dashboard.