How to add a search box to a table in Power BI

Richard Linderman 25

Don't know whether I've selected the right tag for this, but anyway.

I've created a table visual within Power BI and I wanted to have a filter within the table itself to search for values within the table based on text, i.e. say I have a name value and I wanted to search within the table for individuals with "Smith" in their name.

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Richard Linderman 25 Reputation points

2024-07-31T13:21:50.16+00:00

Thanks for giving me this answer. However, it is not available to me. Would you be able to know any other methods?

3 answers

Andrés Madrigal 25 Reputation points

2024-08-13T16:49:22.1566667+00:00

You can add visuals to every project using the "Get more visuals" option from the Vizualizations menu.

You could chose text filter from Microsoft, or another visual from someone else
Please sign in to rate this answer.

5 people found this answer helpful.
Pedro Nalin 0 Reputation points

2025-01-21T08:15:11.0666667+00:00

Awesome, thanks!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Syed Saleem Peera 11,590 Reputation points Microsoft Vendor

2024-07-31T05:54:42.5333333+00:00

Hi Richard Linderman,

Thank you for reaching out to us on Microsoft Q&A forum.

You can add the slicer visual and then go to the more options (three dots) in the visual header. There, you can find the 'Search' option. If you enable that, you will get the search functionality in the slicer. Kindly refer the below screenshot.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.
Please sign in to rate this answer.
Richard Linderman 25 Reputation points

2024-07-31T13:11:07.0266667+00:00

Thanks for giving me these answers. However, neither of them are available to me. Would you be able to know any other methods?

Richard Linderman 25 Reputation points

2024-07-31T13:21:57.4666667+00:00

Thanks for giving me this answer. However, it is not available to me. Would you be able to know any other methods?

Syed Saleem Peera 11,590 Reputation points Microsoft Vendor

2024-08-01T06:47:37.8+00:00

Hi Richard Linderman,

Thank you for your patience.

Add a Filter Visual: You've already done this by placing the filter visual in the report canvas.

More Options (Three Dots): Click on the filter visual. Then, in the filter panel, look for the "More options" icon, represented by three vertical dots.

Enable Search: In the options, you will find a "Search" checkbox or option. Tick this box to enable the search functionality within the filter.

This will allow you to type text, such as "Smith," and filter the visual to show only relevant data. Kindly refer the below screenshot.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.

Richard Linderman 25 Reputation points

2024-08-01T08:44:05.3333333+00:00

No, none of these exist for me either. What I'm asking for is for the filter to appear on the table itself, i.e. something like a magnifying glass symbol appearing next to the names on the column headers which, when clicked, bring up the option to type a name in to find something.

Syed Saleem Peera 11,590 Reputation points Microsoft Vendor

2024-08-01T15:14:08.8033333+00:00

Hi Richard Linderman,

While Power BI doesn't support in-table search icons like a magnifying glass directly in table headers, these methods provide powerful and user-friendly alternatives to search and filter data within your reports.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.

Syed Saleem Peera 11,590 Reputation points Microsoft Vendor

2024-08-02T04:16:23.8766667+00:00

Hi Richard Linderman,

Just checking in to see if you had a chance to see the previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.

Syed Saleem Peera 11,590 Reputation points Microsoft Vendor

2024-08-03T03:27:26.13+00:00

Hi Richard Linderman,

I wanted to check if you had the opportunity to review the information which was provided in our previous answer. Please feel free to contact us if you have any more quires. If you feel that your quires have been resolved, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post.

Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Harel Raj 0 Reputation points

2024-07-31T13:43:24.5966667+00:00
Hi Richard,

If the previous answers didn't help you, I recommend using the method that Syed has mentioned above. To make sure that there is no confusion with the method, I will list out the steps in bullet points.

Add a slicer visual to your Power BI workspace

Make sure that the slicer has data (You can do this by changing the field section or by dragging and dropping the preferred data onto the slider itself).

Hover over the slicer and press the "More Options" button (Three dots button) and press "Search" Hope this helps, please make sure to accept this answer if it works for you!
Regards.
Please sign in to rate this answer.
Wendy J. Wibbens 0 Reputation points

2025-02-20T18:44:51.8366667+00:00

It's unfortunate that this method, and the Microsoft Text Filter, only work for searching pure text fields. I need to search short strings that are a combination of text and numbers. Any help?

Syed Saleem Peera 11,590 Reputation points Microsoft Vendor

2025-02-21T05:34:43.5366667+00:00

Hello Wendy J. Wibbens,

Could you clarify the issue a bit more? Are you looking for a way to search mixed text and number values within a table visual, or are you facing issues with filters not recognizing these values correctly? Also, are you using a specific visual like a slicer or text filter?

Wendy J. Wibbens 0 Reputation points

2025-02-21T15:42:05.27+00:00

Good morning, @Syed Saleem Peera - thanks for responding. I tried again this morning and found Search in a new location in the slicer (the video I'd watched was a few years old) and it's working great for my strings of text and numbers (A12345). I appreciate you reaching out!

Syed Saleem Peera 11,590 Reputation points Microsoft Vendor

2025-02-24T05:24:41.3966667+00:00

Hi Wendy J. Wibbens,

Glad to hear it’s working for you! If you have any other questions or need further guidance, feel free to reach out.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to add a search box to a table in Power BI

3 answers

Your answer