What is a Power BI Slicer

A Power BI slicer helps you filter your data. It is a visual tool in Power BI reports. With slicers, you choose what values to show. They are simple to set up. This article will show you how to make and use different types of Power BI slicers.

Button Power BI Slicers

Buttons are a great way to slice data, especially when using touchscreen devices, like tablets and cell phones.

The ease by which items can be selected and deselected makes this type of Slicer a fan favorite.

To create Button Slicers, begin by adding a Slicer visual to a report and populating the Field with the desired data model item.

To change this default format to Buttons, select Visualizations -> Format Visual -> Slicer Settings -> Options -> Style and change the current setting to Tile.

Button Power BI slicer

When resizing the Slicer, the buttons are responsive.  In other words, if you make the Slicer tall, the buttons are stacked atop one another.  If you make the Slicer wide, the buttons appear side-by-side.

By default, multiple buttons can be selected by holding the CTRL button.  If you want each button to act as a toggle (on or off when clicked), change the Selection option labeled “Multi-select with CTRL”.

Multi-select button Power BI slicer

If you want the user to be limited to selecting only a single button at any time, activate the Selection option labeled “Single Select”.

Other customization options for Power BI slicer include:

  • Display a heading
  • Background color
  • Border color
  • Button color
  • Button border color and thickness
  • All standard font controls

PRO TIP: When customizing the color of the unselected buttons, it can become unclear as to which are the selected versus unselected buttons.  It’s best to go with a color that is similar to the background color for unselected buttons.

Featured Course

Fast Track to Power BI

Stay ahead of the game in 2024. Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional. This course gets you started in Power BI – Fast!
Learn More
Power BI Course image

List & Hierarchy Power BI Slicers

List Slicers

The default style for Slicers is the List.

Like the Button style, the user can use the CTRL key to select multiple values.  This behavior can be reset to a toggle or as a single select as demonstrated with the Button style.

Excluding Items From a Slicer

If a Slicer contains an item that you wish not to be filtered, you can easily remove the items from the list without any fancy custom Measures.

Right-click the item in the slicer and select Exclude.

Exclude items from Power BI Slicer

When hovering over the “Applied Filters” icon, the excluded field item will be listed so users don’t think something is unintentionally missing.

If you would rather not let the user know that an item has been removed, expand the Filters panel and locate the excluded item.  Click the “eye” icon so that it appears as an “eye-slash” icon.  This will make it appear as if all data is visible to the user.

To reinstate the excluded item, click the “X” next to the desired item.

Creating a Hierarchy Slicer

To create a Slicer that presents a hierarchy of data, it’s not necessary to create a hierarchy of data in the Data Model.  All that is needed is to add multiple fields to the Slicer’s logic.

The controls for expanding and collapsing the hierarchies as well as controlling the indentation depth are found in the Hierarchy options.

If space is a premium, or when using a single-select option, the Slicer can be made into a Dropdown list that minimizes once a selection has been made.

dropdown slicer in Power BI

This option is located under Slicer Settings -> Options -> Style.

Featured Course

Master Excel Power Pivot & DAX (Beginner to Pro)

Transforming data into meaningful reports can feel like being in an Olympic event. It is hard! Join the course and learn how to use Excel’s Power Pivot and Data Modelling tools to make reporting easy and fast.
Learn More
Power Pivot DAX course cover

Numeric (Range) Power BI Slicers

Range Slicers are useful when you need to filter your data based on a numeric range.

There are three options available when filtering by a range of numeric data:

  • Filter data that is greater than a set value
  • Filter data that is less than a set value
  • Filter data that are between two set values

For example, suppose we have a table showing the total sales for all products in our “Party” department.

Numeric (range) slicers

We’d like to see total sales for products that are below a certain cost.

Adding a Slicer that uses the “Cost” field of our Product table, automatically presents a range slider.  This is because the field has been assigned a numeric data type.

The two circular handles allow us to set the range of costs to anywhere between the lowest and highest costs in the data model’s “Cost” field.

To change the range logic between the three previously mentioned behaviors, select the Range Slicer and navigate to the Slicer’s formatting controls and alter the Style option in the Slicer Settings section of controls.

Timeline (Range) Power BI Slicers

Like the Numeric Slicers, the Timeline Slicers allow you to filter a visual based on a selected range.

Date ranges can be set according to the following logical constructs:

  • Filter data that is greater than a set date
  • Filter data that is less than a set date
  • Filter data that are between two set dates
  • Filter data that is relative to a set date window
  • Filter data that is relative to a set time window

When adding a Slicer that uses a field set to a Date data type, the Power BI Slicer will default to a Range Slicer that provides the user with start date and end date options.

Timeline slicer in Power BI

The user can adjust the start date and end date controls in the same way as the Numeric Range Slicer.

Calendar Picker controls are also available to make date selections easier.

Calendar picker in Power BI slicer

To change the range logic between the previously mentioned behaviors, select the Date Range Slicer and navigate to the Slicer’s formatting controls and alter the Style option in the Slicer Settings section of controls.

One of the more interesting options, “Relative Date”, allows the user to define the ‘last/next/this’, ‘days/weeks/months/years’, and interval.

Pro Tip: Synchronizing Slicers Between Report Pages

It’s not uncommon to want to make Power BI Slicer selections on one page, and have those selections carry over to another page.  This is a great time saver when developing a report as it eliminates the need for creating the same Slicer on multiple pages.

To edit the behavior of a Slicer across report pages, activate the Sync Slicers pane by selecting View (tab) -> Show Panes (group) -> Sync Slicers.

With a Power BI Slicer selected, this panel presents a list of all pages in the report.  Two control columns are presented for each report page: a “sync” control and a “visible” control.

Sync Power BI slicer between report pages

Checking or unchecking a “sync” control for a specific page will enable/disable synchronization between the Slicer and copies of the Slicer on other pages.

Checking or unchecking a “visible” control for a specific page will show or hide the Slicer on other pages.

NOTE: Checking the “visible” box for a report page that does not contain the selected Slicer will automatically create the Slicer on the selected page.

Although copying and pasting a Slicer to another page places and sizes the Slicer exactly as the original Slicer, the pasted Slicer can be freely moved and resized without affecting the original Slicer.

You can have ‘invisible’ synced slicers but that can lead to confusion about the filters affecting the visuals on a page.  You can always look them up by hovering over the funnel icon in the corner of the visual, but this might not be intuitive to your end users.

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.