How to Add Search Filter in Power BI

Scrolling through endless dropdown lists to find a specific product, customer, or campaign in a Power BI report is a quick way to lose your audience's attention. A simple search bar can transform your static report into a user-friendly, interactive tool. This guide will show you exactly how to add a search filter in Power BI, putting the power of discovery right at your users' fingertips.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why a Search Filter is a Game-Changer for Your Reports

Before jumping into the "how," let's quickly cover the "why." Imagine you've built a comprehensive sales dashboard for your team. It shows sales by region, product performance, and customer lifetime value. Without a search filter, a sales manager wanting to see data for just one specific client, "MegaCorp Inc.," has to scroll through a potentially massive list of all your clients. It's slow and cumbersome.

Now, picture the same dashboard with a search bar. The manager simply types "MegaCorp" and clicks the result. Instantly, every chart and table on the page updates to reflect data only for that client. This elevates your report in several ways:

• Better User Experience: It makes finding information fast and intuitive, much like searching on a website.
• Increased Interactivity: It encourages users to explore the data and ask their own questions, rather than just passively viewing pre-canned charts.
• Saves Time and Frustration: It eliminates the tedious task of manually hunting for data points within long lists.

In short, a search filter is one of the easiest ways to make your Power BI reports more professional and valuable to the people using them.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Easiest Method: Using the Built-in Slicer Search

Power BI's most straightforward filtering tool is the Slicer visualization. While most people use it to create simple lists or dropdowns, it has a built-in search function that many users overlook. This is the quickest way to add search functionality to your report.

Step-by-Step Guide to Adding a Searchable Slicer

Let’s walk through the process using a common example: creating a searchable filter for a list of products in a sales report.

1. Add the Slicer Visualization

First, open your Power BI report. In the Visualizations pane on the right-hand side, find and click on the "Slicer" icon. This will add an empty slicer placeholder onto your report canvas.

2. Add Your Data

With the new slicer selected, go to the Data pane. Find the field you want to make searchable — in our case, it's 'Product Name'. Drag this field into the "Field" bucket in the Visualizations pane. The slicer will now populate with a list of all your products.

3. Enable the Search Function

Here’s the key step. Your slicer is currently just a long, scrollable list. To add the search bar, click on the ellipsis (...) in the top-right corner of the slicer visual. A context menu will appear. Simply select "Search" from the menu. A search box will instantly appear at the top of your product list. That's it! Your searchable filter is now active. Your users can start typing to quickly narrow down the list and make their selections.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Customizing Your Search Filter for a Better Experience

Now that your search functionality is working, you can refine its appearance and behavior to better fit your report's design.

With the slicer selected, navigate to the Format visual pane (the paintbrush icon). Here are a few essential adjustments you should consider:

Change the Slicer Style

A long vertical list can take up a lot of space on your report. A dropdown is often a better choice when you have a search bar.

• Go to Slicer settings > Style.
• Change the Style from "Vertical list" to "Dropdown".

This collapses the list into a single compact bar, which users can click to expand and search. It's much cleaner and saves screen space.

Adjust Selection Controls

By default, users can select multiple items in a slicer by holding down the Ctrl key. This can be confusing. It's often better to enable a more straightforward selection method.

• In Slicer settings > Selection, you can turn on "Show 'Select all' option" to let users easily select or deselect everything.
• You can also enable "Single select" if you want users to only be able to filter by one item at a time.

Add a Clear Title

Don’t make users guess what your filter does. Always give it an intuitive title.

• Expand the General tab in the formatting options.
• Turn on the Title and type in something descriptive, like "Search for a Product" or "Filter by Customer."

Advanced Filtering: Finding Text That Contains Your Search Term

The standard Power BI search filter has one limitation: it only finds results that start with your search term. If you search for "Shirt," it will find "Shirt, Blue" and "Shirt, Red," but it won't find "T-Shirt, Blue."

For a true "contains" search, you can use a custom visual from AppSource. AppSource is Microsoft’s marketplace for third-party visuals that add functionalities not included in Power BI by default. The best choice for this is the free "Text Filter" visual made by Microsoft.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Use the "Text Filter" Custom Visual

1. In the Visualizations pane, click the ellipsis (...) at the bottom and select "Get more visuals."
2. In the AppSource window that opens, search for "Text Filter" and click "Add" to install it.
3. A new icon for the Text Filter will appear in your Visualizations pane. Click it to add it to your report canvas.
4. Just like with the slicer, drag the text field you want to filter (e.g., 'Product Name') into the "Category" field for the visual.

Now, you have a simple text input box. When a user types a word into this box, it will filter the report to show any items that contain that word anywhere in the text. This is much more powerful and aligns better with how users expect search to work.

Best Practices for Implementing Search Filters

As you add search filters to your reports, keep these best practices in mind to ensure a great user experience and optimal performance.

• Place Filters Intuitively: Users typically expect to find filters and search bars at the top or on the left-hand side of a dashboard. Place them in a consistent, predictable location across all of your report pages.
• Be Mindful of Performance: Try to avoid using a search filter on a column with extremely high cardinality (millions of unique values), like a Transaction ID. Filtering such a large volume of distinct values can sometimes slow down report performance. Customer names, product SKUs, and campaign names are perfect candidates.
• Provide a 'Reset' Option: The default "Clear selections" eraser icon on the slicer is useful. For complex dashboards with multiple filters, consider creating a dedicated "Reset all filters" button using a Power BI bookmark to give users an easy way to return to the original, unfiltered view.

Final Thoughts

Adding a search filter is a simple yet impactful way to elevate your Power BI reports from static data displays to dynamic, useful tools. Whether you're using the built-in slicer search or a more advanced custom visual, you're empowering your users to explore data on their own terms, making your insights more accessible and actionable.

While Power BI is a formidable application, getting to this point often involves navigating a considerable learning curve of visuals, data models, and obscure settings. We built Graphed because we believe getting insights from your data shouldn't be so complex. We use AI to let you build real-time, interactive dashboards just by asking questions in plain English. Instead of manually adding and configuring filters, you can just ask, “Show me my total website traffic from mobile in the US last week,” and Graphed instantly builds the live, interactive report for you - no complex setup required.