Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Hi @mterry
i tryed make another example on @v-yuezhe-msft solution. Look:
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
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,
Happy to help!
Okay looks like that may be what I was looking for - thanks to all in this string for the help.
@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
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:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |