How to "Search" Multiple Part Numbers in Power BI all at once?

[Anonymous]

Hi everyone,

Is there a way that I can somehow input a list of items into Power BI to retrieve all the related info?

Right now, the table/slicer can either only display all items or items that match the slicer criteria.

I want to be able to input specific part numbers (lets say 10 specific parts) into the table and get that info only (ideally copy-paste).

Is PowerBI only capable of searching one item at a time or a close match?

So for example: Right now the table is showing all possible part# at once. A slicer can narrow it down but only general criteria.

I want to somehow just input 5-10 part #'s and get the info related to it.

Example: Copy/paste part# 123, 125,174,146,1555 = brings up only those part's related info

[lbendlin · Accepted solution]

This will do what you want

https://blog.pragmaticworks.com/power-bi-custom-visuals-filter-by-list

Warning: Check for privacy issues before using external visuals.

[Anonymous]

Works perfectly. Thanks!

[Prakruthi72]

Hi,
Could you please let me know the steps you used to make this work?
I'm having a very similar issue and I'm unable to get a solution.

[parry2k]

@Anonymous out of box slicer doesn't' have option to do search multiple values, but you can check if there is custom visual available on the market place.