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.

1. Assigning data

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

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.

2.2. Sort

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

2.3. Font style

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

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.

3.2. Style

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

3.3. Gap

Set the distance between the header and the slicer options.

3.4. Position

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

3.5. Alignment

Set the horizontal alignment of the slicer header.

4. Miscellaneous options

4.1. Multi select

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

4.2. Show select all

Allow users to select all the options in one go.

4.3. Show search bar

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

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.