Search Box

[Anonymous]

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 · Accepted solution]

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 · Accepted solution]

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.

[Anonymous · Accepted solution]

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