Search Box

I need to create a search bar on power bi.

The user inputs ID, which filters a table viz I have created.

The search bar must not have a drop down feature.

The result should only display table values for the ID typed in.

If no ID is typed in, the table must remain EMPTY.

I have tried using slicer and text filter add in.

However, when cleared, the entire table contents are visible.

Anonymous
2 years ago
You could use Bookmarks to save a version of report with blank table. WHen the Clear button is pressed, it goes to the bookmark.
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Mastering Power BI Bookmarks - YouTube
Anonymous
2 years ago
Hi Anonymous ,

You might try the what-if parameter.
Here is my sample data:

I create a What-if parameter here:

Close here and the slicer will only have a search bar:

Then use the DAX below to create a new measure in the data table:

SelectedData = IF( SELECTEDVALUE('Table'[ID], 0) = 'Parameter'[Parameter Value], 1, 0 )

Apply 'Filters on this visual' as shown below:

The final result is shown below:
Without input:

Input 1:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Search Box.pbix28 KB

Forum Discussion