Power BI – Slicer Introduction

Last modified date

Slicer Series

This series will cover different topics regarding slicers.

Power BI reports can be made more flexible using simple slicers to allow your report consumers to slice and dice the data down to what they are interested in. This post will look at the various options for formatting slicers in different ways.

YouTube Version

youtuve link
YouTube version

Simple Slicer

Click on the slicer from Visualizations pane to add a slicer to your report.

add slicer

Then you need to drag in the value you would like to slice by, for example Shop Name. Your slicer is now ready to use.

add field to slicer

You can select a single value in the slicer just by clicking. You can select multiple items by holding down the Ctrl key. To clear the slicer click the eraser icon in the top right.

Eraser icon

Selection Options

Our slicer tick list can be tweaked in various ways to make the report fit different requirements. These options can be found in Formatting (click on the paint roller) and Selection Controls.

Single select will turn the selection boxes into round radio buttons. Only one item can now be selected and there is always one item selected, i.e. you can no longer select all.

single select in slicers

Turning off Multi-select with CTRL will no longer require the ctrl key to be selected to select multiple options. This does mean you need to un-select items to remove filters. This is great for touch screens. You also get little ticks in the boxes.

multi-select in the slicer

Show “select all” adds an option at the top of the list that will toggle turning them all on or off. Showing the “Select all” is great for when report readers will want all excluding one. Some report readers find the concept of selecting none gives you all a hard one to get their head around.

select all in slicers

Button Slicers

When there are only a few options in a list can be effective to change from a list to buttons. This option is not the most intuitive but easy to find when you know how.

Select Format – General and change the Orientation from Vertical to Horizontal and you get buttons!

slicer buttons

Dropdown Slicers

When a list of options is long the tick list takes up too much screen space and becomes hard work to use. So we can change a tick list into a drop down.

In the top right hand corner of the slicer box there is a drop down, which only shows when your cursor is over the slicer. On a simple list slicer this drop down offers List or Dropdown. Selecting Dropdown will reduce the list into a smaller drop down.

dropdown slicers

Adding Search

When a slicer has lots of options it can be useful to add a search box to the slicer. The most common place to add this is probably the drop-down but it can be added to almost any slicer.

Click on the three dots at the top of the slicer window, or the the bottom if your slicer is at the top of the page! Select Search. This will add a search box to the top of the slicer options and will filter the options to match any text.

adding search to slicer

Range Slicer

Dates and numbers don’t work well for a list so when you add a number or date column to a slicer it will default to a range slicer. This slicer has two handles that allow you to modify the range selected.

range slicers

Clicking the top right drop down will offer Between, Before and After as different range options as well as converting to List or Dropdown.

Conclusion

There are many options for slicers, you need to know your audience and which slicers they will prefer. So make sure it is obvious to your users what they are filtering. If you need slicers to filter slicers take a look at Cascading slicers.

Over 20 year experience at being passionate about training, solving problems and loving a new challenge especially in the Microsoft's Power Platform suite.