How To Add A Search Bar In Power Bi Table

by

Adding a search bar in Power BI table

Here’s how you can add a search bar to a table in Power BI:

  1. Open your Power BI report and go to the page where you want to add the search bar.
  2. Click on the “Insert” tab on the top menu.
  3. Select “Text box” from the “Text” section.
  4. Click and drag on the report canvas to create a text box.
  5. With the text box selected, go to the “Visualizations” pane on the right.
  6. Under “Values,” select the column you want to search within your table. This could be the column that contains the text data you want to filter.
  7. Go to the “Format” section of the “Visualizations” pane.
  8. Expand the “Search” option.
  9. Toggle the “Search bar” option to ON.
  10. Adjust other formatting options like placeholder text, font size, and color as per your preference.

Once you have followed these steps, you will see a search bar displayed on your table. Users can now enter search terms to filter the table based on the selected column.

Example:

Let’s say you have a Power BI table displaying customer data, and you want to add a search bar to filter customers based on their names.

  1. Create the text box as mentioned above.
  2. Select the “CustomerName” column under “Values” in the “Visualizations” pane.
  3. Toggle the “Search bar” option to ON.
  4. Customize the formatting options for the search bar.

Now, when you view the report, the search bar will be visible above your table. Users can type in a customer name, and the table will dynamically filter based on the input.

Leave a comment