Power BI Desktop has many different ways to filter the data that is displayed. One of these is using slicers. The slicer provides a much better user experience than the filter pane making the dashboards created much more intuitive for people to use. They also blend more seamlessly with the design produced.
An example of what a text slicer could look like is shown below.
Adding a Text Slicer
- From the Visualisations Pane select the Slicer icon
2. Add the field to be sliced by to the Field box by dragging it from the Fields Pane
2. A list of the unique options for that field will be produced
3. Tick the required data to view only that information
NOTE: More than one field can be added to a slicer. This will produces subsets of the list that can be selected.
Removing a Text Slicer
There are 2 ways to remove a text slicer.
- Untick the tick box already ticked
- Click on the Eraser that appears when you hover over the top right of the slicer visualisation
Changing the Text slicer from a List to a Drop down menu
By default a text slicer shows the options available in a list but if this list is long it may be better shown as a drop down box which expands when it is clicked on. This takes up less space on the report but requires an extra click to access it.
- Hover over the top right of the Slicer Visualisation
- Click on the drop-down arrow and change the option from List to Drop Down (this appears after the eraser icon already mentioned)
Formatting the Text Slicer
Like all visualisations in Power BI there are options that can be altered to change how the visualisation looks and behaves.
- Click on the slicer visualisation already produced
- Click on the Format your Visual tab in the Visualisation Pane
- There are 3 slicer specific options.
a) Slicer Settings
i. Orientation. The orientation can be changed from vertical to horizonal. If this is done the tick boxes are replaced with buttons. This can work well as long as there are not too many options to choose from
ii. Selection. By default options from the slicer are clicked on to select them and selecting a second option deselects the first unless the CTRL key is held down. The selection options allow for only single items to be selected, allow multi selecting without the need to hold the CTRL key and to show a Select all option at the top of the list of items to make it easier to select and deselect everything
b) Slicer Header. The label at the top of the slicer can be turned on or off or renamed and the formatting of it can be altered too.
c) Values. The formatting of the items in the list can be altered.
If you’ve enjoyed reading how to use the Text Slicer in Power BI Desktop, there’s some other blogs below that you might find useful: