How To Add Search Bar In Power Bi

How to add a search bar in Power BI

To add a search bar in Power BI, you can follow these steps:

1. Open Power BI Desktop and navigate to the report page where you want to add the search bar.
2. In the Visualizations pane, search for the “Text box” visual and drag it onto the report canvas.
3. Now, select the newly added text box visual and go to the “Format” tab in the Visualizations pane.
4. Under the “Data colors” section, turn on the “Outline” option and choose a desired color for the outline.
5. Then, go to the “General” section and enter a desired placeholder text for the search bar in the “Default Text” field.
6. You can further customize the appearance of the search bar by adjusting properties like font size, alignment, etc., under the relevant sections in the “Format” tab.
7. Once you are satisfied with the search bar’s appearance, you can use Power BI’s built-in filtering capabilities to enable search functionality.
8. For example, if you have a table visual that you want to search within, you can select that visual and go to the “Visualizations” tab in the Visualizations pane.
9. Under the “Data” section, you can add a filtering condition to the table’s columns based on the value entered in the search bar.
10. For instance, you can use the formula “CONTAINS(Column_Name, searchText)” to filter the table’s column based on the search text entered in the search bar.
11. Finally, you can test the search bar functionality by entering a search term in the text box and seeing the corresponding updates in the filtered table visual.

By following these steps, you can add and configure a search bar in Power BI to enhance user interaction and enable text-based filtering within your reports.