How to Add a Search Box in Power BI Report

Power BI is fantastic for visualizing data, but a report full of charts and tables can still be overwhelming if users can’t find what they need. Adding a search box can transform a dense report into a user-friendly, interactive tool. This article will show you two effective methods for adding a search capability to your Power BI reports, from a simple built-in option to a more powerful, dynamic solution.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother Adding a Search Box?

Before diving into the "how," let's quickly cover the "why." A search box significantly improves the user experience of your report, especially when dealing with large datasets. Imagine trying to find a specific product manager, customer, or transaction in a slicer with thousands of entries - it's a recipe for frustration.

A search box provides several key benefits:

• Saves Time and Effort: Users can bypass endless scrolling and find specific data points instantly.
• Boosts Interactivity: It encourages users to explore the data by making it easier to drill down and investigate points of interest.
• Empowers Non-Technical Users: A familiar search bar makes reports more accessible to team members who aren't data experts and may be intimidated by complex filter panes.

In short, it’s a small addition that makes your reports more professional, efficient, and approachable for everyone.

Method 1: The Easy Way with a Slicer's Built-in Search

The simplest way to add search functionality is to enable the search feature that already exists within Power BI slicers. This method works perfectly when you want to allow users to search for values within a single field, like a customer name, product ID, or city.

It’s fast, requires no code, and is a great first step toward a more interactive report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide to Enabling Slicer Search

1. Add a Slicer to Your Report: Go to the Visualizations pane and select the Slicer icon. Drag it onto your report canvas.
2. Assign a Data Field: Drag the field you want to make searchable (e.g., 'Product Name' from your Products table) into the "Field" well of the slicer visualization. By default, it will probably appear as a list.
3. Enable the Search Option: This is the key step. Hover over the top-right corner of the slicer visual on your canvas until an ellipsis (...) appears. Click it, and you'll see a 'Search' option in the dropdown menu. Click Search.

That's it! A small search bar will instantly appear at the top of your slicer list. Now, you or your users can type directly into that box to filter the list and quickly find the specific item they’re looking for.

Pro Tip: By default, this search looks for matches anywhere in the string. If a user types "Desk," it will find "Adjustable Desk," "Office Desk," and "Desktop Computer Stand." It’s intuitive and works how most people expect a search bar to work.

Pros and Cons of This Method

• Pros:
• Cons:

Method 2: Building a Dynamic Multi-Field Search Box with DAX

For a true dashboard experience, you might want a single search box that can look for a keyword across multiple text fields at once. For example, maybe you want to find all transactions related to "electronics," whether that word appears in the product name, the category, or a product description column.

This requires a slightly more advanced approach using a custom visual and a simple DAX measure. Don't worry, it's more straightforward than it sounds!

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Concept Explained

We are going to create a search system with three parts:

1. An Input Box: We’ll use a free custom visual from the marketplace called "Text Filter" to serve as our search bar.
2. A DAX Measure: This bit of code will check if the user's search term exists in any of the data columns we specify. It will return a 1 if a match is found and a 0 if it isn't.
3. A Visual-Level Filter: We'll tell our charts and tables to only show rows where our DAX measure equals 1.

Step 1: Get the Text Filter Custom Visual

The best way to get a clean, free-form text input box is from the Power BI marketplace (AppSource).

• In the Visualizations pane, click the ellipsis (...).
• Select Get more visuals.
• Search for "Text Filter" and click 'Add'.
• Once added, the new visual icon will appear in your Visualizations pane.

Step 2: Create a Disconnected Table for the Search Input

Custom visuals often need a field to bind to. We'll create a simple one-column, one-row table to hold our search term. This table is "disconnected," meaning it has no relationship to your other tables.

• Go to the Home tab on the Ribbon and click Enter Data.
• A blank table creation window will pop up. Do not enter any data. Simply name the table (e.g., "Search Input") and click Load. You should not need to name the column. This part is a known workaround - a blank disconnected table allows the dynamic nature we require.
• Correction - An even easier way: Go to the Modeling tab and click New Table. Paste in the following DAX formula:
• This creates a simple table named 'Search Input' with one column called 'Search Term'.

Step 3: Create the DAX Search Measure

This is where the magic happens. We’ll write a DAX measure that will do the heavy lifting of searching our text.

• Right-click on your main data table (e.g., your 'products' table) and select New Measure.
• Paste the following DAX formula into the formula bar. Be sure to replace the placeholder table and column names with your own!

Breaking Down the DAX:

• VAR SearchValue = SELECTEDVALUE('Search Input'[Search Term]): This creates a variable called SearchValue and stores whatever the user types into our search box.
• IF(ISBLANK(SearchValue), 1, ...): This first check says, "If the search box is empty, return a value of 1" (meaning, no filter is applied and everything shows).
• CONTAINSSTRING(Products[Product Name], SearchValue): This is the core function. It checks if the text string from our SearchValue variable exists anywhere inside the Product Name column. This is case-insensitive, which is perfect for search.
• ||: This is the logical OR operator. We string multiple CONTAINSSTRING checks together, telling DAX to return a value of 1 if the search term is found in the Name column, OR the Category column, OR the Description column.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Putting it All Together and Applying the Filter

Now we just need to get our search box on the canvas and apply the DAX filter to our visuals.

1. Add the Search Box: Select the "Text Filter" custom visual icon from your Visualizations pane to add it to your report. Drag the Search Term column from your newly created 'Search Input' table into the 'Values' field for the visual.
2. Select a Visual to Filter: Click on a table, matrix, or chart that you want to be affected by the search. For this example, let's use a table visual that displays your products.
3. Apply the Filter: With the table visual selected, go to the Filters pane.

Repeat step 3 for any other visuals you want to be filtered by the search box. Now, when you type into your fancy new search box, any visual with this filter applied will instantly update to show only the results that contain your typed keyword across all the fields you defined!

You can also drag the measure to the "Filters on this page" section to apply it to all visuals on the entire report page at once.

Final Thoughts

Knowing how to add search capabilities takes your Power BI reports from static displays to interactive tools that truly empower your users. The built-in slicer search is perfect for simple, single-field lookups, while the DAX method gives you the power to create a robust, dashboard-wide search experience across multiple fields.

While building interactive reports in tools like Power BI offers incredible control, the process often involves diving into formulas and custom configurations. With Graphed , we created an AI data analyst that lets you skip the setup entirely. You can connect your marketing and sales data, then just use plain English to describe what you want to see. Instead of configuring DAX measures and filters, you can just ask, "Show me my product sales in Canada for each campaign," and get an interactive dashboard in seconds that you can keep chatting with to find more insights.