Easy way to find multiple values

[DouweMeer]

So we have this massive product table and I've imported it BI. Now I was curious how I could easily extract related information of 10 products without going through them 1 by 1. I want to copy paste the 10 product and get the list shown information. Is this do able?

[Anonymous]

Could you show a sample of your data and relationship table so it can help me understand the issue better?

[DouweMeer]

@Anonymous 

So it is just a 1 sheet with x thousand records and x amount of columns. You just want to find pre determined specified columns for a random list of articles. Example below of what I encounter. 

So the idea is I enter for example ZT-1FG3, ZT-1FG5 and ZT-1FG6. Then I get the results from these 3. Currently I would create a list slicer with a search functionality and manually enter them 1 by 1. This is a bit time consuming as I've a list of 20 items to find. 

[Anonymous]

Unfortunately i do not think it is possible to copy/paste multiple values into a filter to filter on them. If the items happen to be the same all the time, for example each monday we need to check these 20 items. you can filter them yourself once and create a bookmark to remember the filter.

Hope this helps as i do not know any other solution.

Goodluck!

[DouweMeer]

@Anonymous 

Sadly enough that is not the case.