Allowing users to search database table

[mterry]

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?

[Anonymous · Accepted solution]

@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.



Regards,

Lydia

[ibarrau]

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,

[mterry]

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

[McCow]

@mterry with pleasure, enjoy

[Anonymous · Accepted solution]

@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.



Regards,

Lydia

[mterry]

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. 

[McCow · Accepted solution]

Hi @mterry

i tryed make another example on @Anonymous solution. Look:

1)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

[mterry]

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.