Table of Contents
Adding a search bar to a slicer in Power BI allows for efficient filtering and searching of data within a report. This feature enables users to quickly locate specific information within a slicer, reducing the time and effort needed to manually scroll through a large amount of data. By simply typing in a keyword or phrase, the search bar will filter the slicer options and display only relevant data. This can be achieved by selecting the slicer and enabling the “Search” option in the Format pane. Overall, adding a search bar to a slicer in Power BI enhances the functionality and usability of reports, making it easier for users to analyze and interpret data.
Power BI: Add Search Bar to Slicer
There are two ways to add a search bar to a slicer in Power BI:
Method 1: Click the three dot ellipses in the top right corner of the slicer
Method 2: Click on slicer and type Ctrl + F
Both methods allow you to quickly add a search bar to the slicer.
The following examples show how to use each method in practice with the following report in Power BI:
Example 1: Add Search Bar to Slicer by Clicking Three Dot Ellipses
One way to add a search bar to the slicer is to click the slicer to make it active.
Then, click the three dot ellipses in the top right corner of the slicer:
Then click Search from the dropdown menu that appears:
This will automatically add a search bar to the top of the slicer:
Once you start typing in the search bar, the options in the slicer will automatically be filtered:
Example 2: Add Search Bar to Slicer by Typing Ctrl + F
Then, type Ctrl + F.
This will automatically add a search bar to the slicer:
If you would like to remove the search bar, simply type Ctrl + F again.
This will automatically remove the search bar from the slicer:
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: