Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mterry
Helper V
Helper V

Allowing users to search database table

I have a report that's currently linked to a database showing how much money has been spent with certain vendors over the past several years. I'm wondering if it would be possible to include a search box in my report that could allow a user with read only rights to search by vendor name, then perform a search in the database that returned all users that fit the string they entered grouped by exact name and possibly other categories that I've defined - like year/quarter/region/etc?

2 ACCEPTED SOLUTIONS
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@mterry,

You can create a slicer using vendor field, when user select specific value in the slicer, the visuals in the report page will be filtered according to the selection. There is an example for your reference.

1.JPG

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @mterry

i tryed make another example on @v-yuezhe-msft solution. Look:

1)1)2)2)

Step 1 - without any searches

Step 2 - beginning of typing "ac" (for ACME example), but will be found all content with this sequence of chars


With [Ctrl] key you can select many related records at once

 

Or it is wrong too?

Best regards

 

 

 

 

View solution in original post

7 REPLIES 7
ibarrau
Super User
Super User

Hi, try the new custom visual "Text Filter" is great.

https://appsource.microsoft.com/es-es/product/power-bi-visuals/WA104381309?src=office&tab=Overview

 

Regards,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Okay looks like that may be what I was looking for - thanks to all in this string for the help. 

@mterry with pleasure, enjoy

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@mterry,

You can create a slicer using vendor field, when user select specific value in the slicer, the visuals in the report page will be filtered according to the selection. There is an example for your reference.

1.JPG

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks but that doesn't really address my issue, which is getting around the different ways a vendor may be entered. For example say there was a company named ACME - that company could have been entered in the system as ACME LLC; ACME - LLC; ACME LLC.; California Project - ACME; ACME - California Project and they all would come through as unique vendors. Many times as you search you'd be able to see the different entries and select multiple, but in the case above you would probably not capture the 'California Project - ACME' entry. So what I really need to have happen is have a user enter "ACME", and have the actual search that Power BI performs be a CONTAINS search. I know this still isn't perfect, but it's an improvement. 

Hi @mterry

i tryed make another example on @v-yuezhe-msft solution. Look:

1)1)2)2)

Step 1 - without any searches

Step 2 - beginning of typing "ac" (for ACME example), but will be found all content with this sequence of chars


With [Ctrl] key you can select many related records at once

 

Or it is wrong too?

Best regards

 

 

 

 

I guess it does serve the purpose I'm looking for since the search seems to go through the entire name for the text string being entered so looks like my concerns were unwarranted. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors