This series will cover different topics regarding slicers.
- Slicers Introduction
- Resetting Slicers with a Bookmark Button
- Cascading Slicers
- Hierarchy Slicer
- Syncing 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.
Click on the slicer from Visualizations pane to add a slicer to your report.
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.
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.
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.
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.
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.
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!
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.
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.
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.
Clicking the top right drop down will offer Between, Before and After as different range options as well as converting to List or Dropdown.
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.
Graham-Brown, L. (2020). Power BI – Slicer Introduction. Available at: https://hatfullofdata.blog/power-bi-slicer-introduction/ [Accessed: 6th April 2020].