Inserting slicers

Dashboards are a warehouse of information. Slicers enable you to focus on specific aspects of your data. Use a slicer to filter the entire dashboard, allowing you to dynamically narrow down the data based on your chosen categories.

Inserting a slicer

1. Assigning data

Assign dimension categories to your slicer from the pivot data window.

Assiging dimensions to slicers

2. Configuring the slicer

You can tailor the look and feel of the slicer from the Config tab.

2.1. Slicer type

Set the look and feel of your slicer with the List/Dropdown/Tile/Tages options.

List

Dropdown

Tile

Tags

2.2. Sort

Slicer categories can be arranged in ascending or descending order. You can also opt for Power BI native sorting.

Sorting option

2.3. Font style

Set the font style, size, and color, and use bold or italicized text formatting.

Font customiztions

3. Customizing the header

You can tailor the look and feel of the slicer header from the Header tab.

3.1. Show header

Disable this toggle to hide the slicer header.

Enable/disable header

3.2. Style

Set bold or italicized text formatting and assign a header color.

Header style

3.3. Gap

Set the distance between the header and the slicer options.

Gap between slicer options and header

3.4. Position

The header can be placed at the top or to the left of the slicer.

Header position

3.5. Alignment

Set the horizontal alignment of the slicer header.

Header alignment

4. Miscellaneous options

4.1. Multi select

Enable the toggle to be able to select multiple options simultaneously.

Multi select

4.2. Show select all

Allow users to select all the options in one go.

Select All

4.3. Show search bar

When you have a large number of options, you can enable the search bar to quickly narrow down categories.

Show search bar

4.2. Show clear filter

The icon at the top right corner can be used to reset all selections. Disable the Show Clear Filter toggle to hide the icon.

Show clear filter