How to Add Search Bar in Power BI Dashboard

Tired of endlessly scrolling through long lists of data in your Power BI dashboards? A well-placed search bar can transform your reports from static displays into interactive tools that let your users find exactly what they need in seconds. This guide will show you two effective ways to add search functionality to your Power BI dashboard, from a simple, built-in method to a more powerful custom solution.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why A Search Bar is a Game-Changer for Your Power BI Dashboards

Before we jump into the "how," let's quickly cover the "why." Adding a search bar is about more than just aesthetics, it's about improving the user experience and enabling quicker data discovery. When you're dealing with hundreds or thousands of product names, customers, or locations, a filter list becomes nearly impossible to navigate.

A search bar provides:

• Speed and Efficiency: Users can instantly pinpoint specific records without scrolling or manually scanning. Want to see sales data for "Premiumwidgets"? Just type it in and the dashboard updates immediately.
• Reduced Clutter: Instead of displaying a massive list of filter options, a search box presents a clean, simple input field, making your dashboard look more professional and less overwhelming.
• Empowered Users: It allows anyone, regardless of their technical skill, to perform ad-hoc analysis. They can explore the data on their own terms, answering spontaneous questions as they arise.

Method 1: The Easy Way with the Built-in Slicer Search

Power BI has a simple, built-in search feature within its Slicer visual. For most use cases, this is the quickest and easiest way to add text filtering to your report. It's perfect for when you just need a straightforward way for users to search through a list of values in a specific column.

Here’s how to set it up in a few simple clicks.

Step 1: Get Your Data Ready

First, make sure you have your dataset loaded into Power BI. For this example, let's assume you have a sales table that includes a column with product names, called 'Products'[Product Name]. This is the column we'll be making searchable.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 2: Add the Slicer Visual to Your Report

In your Power BI report view, navigate to the Visualizations pane on the right-hand side. Click on the Slicer icon to add it to your report canvas. It will appear as an empty box. Feel free to resize and position it where you’d like it to appear on your dashboard - usually near the top for easy access.

Step 3: Connect the Slicer to Your Data Field

With the new slicer visual selected, go to the Data pane. Find the table and text field you want to make searchable. In our case, it's the Product Name column. Drag this field and drop it into the "Field" well in the Visualizations pane for your selected slicer.

You’ll immediately see the slicer populate with a list of all your product names.

Step 4: Enable the Search Function

Now for the magic. Click on the three dots (…) in the top-right corner of the slicer visual's title bar. This will open a context menu. From this menu, simply select Search.

Instantly, a search box will appear at the top of your slicer list. Now, users can type directly into this box, and the list will filter in real-time to show only the items that match their search term. This search bar filters the list of options within the slicer itself, allowing the user to easily find and select the item they want, which in turn filters the other visuals on the page.

This method is incredibly simple and effective for a wide range of needs.

Method 2: A More Powerful Search Box Using DAX

What if you want a search experience that's a bit more flexible? The default slicer search primarily filters the list of selectable items. But what if you want a search bar that acts as a "contains" filter, where typing "widget" shows all product names that contain the word "widget," without the user needing to select them from a list? Or what if you want a standalone text box that filters your entire dashboard?

For this, we can use a clever trick involving a disconnected table and a bit of DAX (Data Analysis Expressions). It may seem more complex, but it offers far greater flexibility.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 1: Create a Disconnected Table for Search Input

First, we need a place to store the user's search text. We'll create a new, separate table that isn't connected to any other tables in your data model.

1. In the Home tab of the Power BI ribbon, click on Enter Data.
2. A "Create Table" window will pop up. In the first column, give it a name like Search Term. You don't need to enter any rows of data.
3. Name the table something descriptive, like SearchInput, and click Load.

You now have a simple, one-column table that exists purely to capture text from a slicer.

Step 2: Add a Slicer for the Search Term

Just like in the first method, add a new Slicer visual to your report. But this time, drag the [Search Term] field from your newly created SearchInput table into the slicer's field well.

This slicer won't do anything... yet. It's just an input box. To make it feel more like a search bar, you'll want to enable the same Search function on this slicer by clicking the three dots.

Step 3: Write the Filtering DAX Measure

This is where the real work happens. We need to create a DAX measure that checks if the text typed into our new slicer exists within the product names of our main data table.

Right-click on your main data table (e.g., Products) in the Data pane and choose New measure. In the formula bar that appears, enter the following DAX code:

Search Filter = 
VAR SearchValue = SELECTEDVALUE(SearchInput[Search Term])
RETURN
IF(
    ISBLANK(SearchValue), 
    1, 
    IF(
        CONTAINSSTRING(MAX('Products'[Product Name]), SearchValue),
        1,
        0
    )
)

Let's break down what this measure does:

• VAR SearchValue = SELECTEDVALUE(SearchInput[Search Term]): This line stores the text that the user types into our new search slicer in a variable called SearchValue.
• IF(ISBLANK(SearchValue), 1, ...): This checks if the search box is empty. If it is, it returns a 1. This means that when nothing is searched, all data will be shown.
• IF(CONTAINSSTRING(MAX('Products'[Product Name]), SearchValue), 1, 0): This is the core logic. CONTAINSSTRING() is a case-insensitive function that checks if the product name contains the SearchValue. If it finds a match, the measure returns 1, otherwise, it returns 0.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 4: Apply the Measure as a Visual-Level Filter

Your DAX measure is ready, but it won’t do anything until you tell your visuals to use it as a filter.

1. Select the visual on your report that you want to filter (for example, a large table showing all your product sales).
2. Go to the Filters pane. You should see "Filters on this visual."
3. From the Data pane, find your new [Search Filter] measure and drag it into the "Add data fields here" section of "Filters on this visual."
4. Once added, configure the filter. Change the "Show items when the value" dropdown to is and type 1 into the text box.
5. Click Apply filter.

Now, test it out! Type a word into your search slicer. The table visual you applied the filter to should automatically update to show only the rows where the product name contains your searched term. You can drag this same measure onto any other visual you want to be controlled by the search box.

Best Practices for a Great Search Experience

Adding the functionality is one thing, but making it user-friendly is another. Here are a few tips:

• Provide Clear Instructions: It may be helpful to add a simple text box above the search bar that says something like, “Search by Product Name.”
• Include a 'Clear' Button: Power BI doesn't have an obvious "clear slicer" icon. You can create one easily with a bookmark. Simply clear the slicer’s selection, then create a new bookmark with 'Data' deselected. Assign that bookmark to a Button or Image visual, giving users a one-click way to reset the search.
• Place it Strategically: Put your search box in a prominent, intuitive location, typically at the top-left or top-right of your report. Consistency is key if you have multiple report pages.

Final Thoughts

Implementing a search bar in your Power BI dashboards elevates them from static reports to dynamic, user-friendly tools. Whether you use the simple built-in slicer search for quick filtering or the more versatile DAX method for a "contains" search, you're empowering your audience to find the specific insights they need with minimal effort.

Of course, building interactive dashboards in tools like Power BI takes time and a bit of a learning curve. For many marketing and sales teams, the real goal isn't necessarily becoming a dashboard expert, but simply getting fast answers from their data. We built Graphed for this exact reason. Instead of wrangling visuals and writing formulas, you connect your data sources (like Google Analytics, Shopify, or Salesforce) and just ask questions in plain English, like "Show me my sales from organic search last month." It handles the difficult parts, creating dashboards and reports for you in seconds, so you can focus on the insights, not the setup.