How To Add Search In Power Bi Slicer

How to Add Search in Power BI Slicer

To add search functionality to a Power BI slicer, you can follow these steps:

1. Open Power BI Desktop and go to the report where you want to add the slicer.
2. Select the slicer visual in your report.
3. In the Visualizations pane, navigate to the Format section (paint roller icon).
4. Expand the General section if it is not already expanded.
5. Toggle the “Search” option to “On” to enable search functionality for the slicer.
6. Customize the search options if needed, such as enabling/excluding relative dates or filtering options.
7. Save the report and publish it to Power BI service or share it with your intended audience.

Example: Let’s say you have a dataset with a “Product” column and you want to add a slicer for easy filtering. To add search functionality to this slicer, follow the steps mentioned above. Once you enable the search option, users will be able to search for specific products in the slicer, making it easier to find and select the desired items.