How to Search in Power BI Table

Trying to find a specific piece of information in a massive Power BI table can feel like searching for a needle in a haystack. But it doesn't have to be. Power BI provides several ways to search and filter your data, from simple, built-in features to powerful, custom search boxes. This tutorial will walk you through the different methods for searching within a Power BI table, so you can stop scrolling and start finding what you need, fast.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Easiest Method: Using Slicers and Filters

The quickest way to add search functionality to a Power BI report is by using the default Slicer and Filter panes. These tools are perfect for straightforward filtering on a single column without writing any code.

Using a Slicer for Quick Searches

A slicer is a visual element that allows users to filter other visuals on the report page. You can easily turn a slicer into a search bar for any text-based column in your table.

Here’s how to set it up:

1. Select the Slicer Visual: In the "Visualizations" pane, click on the Slicer icon. This will add a blank slicer to your report canvas.
2. Add Your Data Field: Drag the text column you want to search (for example, "Product Name" or "Customer Name") from the "Data" pane into the "Field" well of the new slicer.
3. Enable the Search Option: With the slicer selected, click the ellipsis (...) in the top-right corner of the slicer visual. In the dropdown menu that appears, select "Search." This adds a search bar at the top of your slicer list.

Now, users can simply type into the search bar within the slicer, and the list will dynamically filter. Selecting an item from the filtered list will then filter the main table visual and any other related visuals on the page.

Pro Tip: By default, the slicer appears as a list. For fields with many unique values, you can change its format. With the slicer selected, go to the "Format visual" pane (the paintbrush icon), open "Slicer settings," -> "Style," and change the style to "Dropdown." This saves valuable screen space, and the search function works just as well within the dropdown.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Using the Filters Pane for Targeted Filtering

The Filters pane is another user-friendly, no-code option. It's always available on the right side of the Power BI Desktop environment and can be configured to allow users to filter data directly.

1. Select Your Table Visual: First, click on the table you want to filter to make it active.
2. Drag a Field to the Filters Pane: From the "Data" pane, drag the column you want to search (e.g., "Region") into the "Filters on this visual" section of the Filters pane.
3. Configure the Filter: A small card will appear for the "Region" filter. You can leave it on "Basic filtering," which provides an easy to read list of checkboxes. Or, for a more search-like experience, change the "Filter type" to "Advanced filtering." This lets you use rules like "contains," "starts with," "is not," etc., giving users more control over their search criteria.

While effective for technical users, the Filters pane is less intuitive for casual report viewers than a dedicated search box on the canvas. For building user-friendly, interactive reports, the next method is often the best choice.

Building a Dynamic, Multi-Column Search Box with DAX

What if you want to search for a term across multiple columns at once? For instance, you might want to find a product by typing in its name, its category, or a word from its description. Slicers only work on a single column. This is where you need to build a custom search solution using a little bit of DAX (Data Analysis Expressions).

Don't worry, even if you’re new to DAX, this step-by-step process is easy to follow.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Create a Disconnected Table for Search Input

Our first step is to create a special, tiny table that isn't connected to our main data model. Its only job is to capture the text that the user types into our search box. This prevents the search box itself from being filtered out as we type.

1. In the "Home" tab of the Power BI ribbon, click on "Enter data."
2. A "Create Table" window will pop up. Rename the column header to something intuitive, like "Search Term." You don't need to enter any data in the rows.
3. Name the table something descriptive, like "Search Parameter," and click "Load."

Now, create a new slicer visual on your report canvas and drag your new "Search Term" field into it. You now have a searchable slicer that will act as our search text box. It doesn't do anything yet, but we'll bring it to life in the next step.

Step 2: Write the DAX Measure to Power the Search

This is where the magic happens. We'll write a DAX measure that checks what the user typed into our search box and then determines which rows in our main table should be visible.

1. Right-click on your main data table in the "Data" pane and select "New measure."
2. This will open the DAX formula bar. Copy and paste the following formula, making sure to replace the placeholder names with your actual table and column names:

Search Filter Active = VAR SearchValue = SELECTEDVALUE('Search Parameter'[Search Term], "") RETURN IF( ISBLANK(SearchValue), 1, // Show all data if the search box is empty IF( CONTAINSSTRING( 'YourDataTable'[ColumnToSearch1] & " " & 'YourDataTable'[ColumnToSearch2], SearchValue ), 1, // Show the row if a match is found in any of the search columns 0 // Hide the row if no match is found ) )

Breaking Down the DAX Formula:

• VAR SearchValue = SELECTEDVALUE('Search Parameter'[Search Term], ""): This line creates a variable named SearchValue. It captures whatever text the user has entered into our "Search Parameter" slicer. If the slicer is empty, it defaults to a blank string ("").
• IF(ISBLANK(SearchValue), 1, ...): This checks if the search box is empty. If it is, the measure returns a 1. We'll use this to show all rows in the table when nothing is being searched.
• 'YourDataTable'[ColumnToSearch1] & " " & 'YourDataTable'[ColumnToSearch2]: This is the key to multi-column search. It concatenates (joins together) the text from multiple columns with a space in between. You can add as many columns as you want to search across using the & " " & pattern.
• CONTAINSSTRING(...): This function checks if the string from our combined columns contains the SearchValue. It's important to note that this function is case-sensitive. If you want a case-insensitive search, you can use the SEARCH function instead.
• IF(..., 1, 0): If CONTAINSSTRING finds a match, the measure returns a 1. If not, it returns a 0.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Apply the DAX Measure as a Filter

Now that our measure is created, the final step is to tell our main table visual to pay attention to it.

1. Select your main table visual on the report canvas.
2. In the "Filters" pane, drag your new measure (in this case, "Search Filter Active") into the "Filters on this visual" section.
3. Expand the filter card for the measure. For the "Show items when the value," select "is" and type 1 into the text box.
4. Click "Apply filter."

That’s it! Now, when you type a term into the search box slicer you created in Step 1, the table will dynamically update to show only the rows that contain your search term across any of the columns you specified in the DAX measure.

Final Thoughts

Searching for specific information in Power BI can be as simple or as sophisticated as you need it to be. For basic, single-column lookups, the built-in slicer with its search functionality is a fantastic, no-fuss option. When your needs are more complex, like searching for a keyword across multiple columns, a DAX-powered search box provides a flexible and powerful solution for your users.

While Power BI is an amazing tool for deep data analysis, its learning curve can be steep, especially when you need to write DAX or configure complex data models. At Graphed we created a tool for people who need quick, clear answers from their sales and marketing data without a complex setup. You can connect sources like Google Analytics, Shopify, and Salesforce in seconds and simply ask questions in plain English to build dashboards and reports in real-time, side-stepping the manual report-building process altogether.