cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DouweMeer Member
Member

Easy way to find multiple values

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?

4 REPLIES 4
Anonymous
Not applicable

Re: Easy way to find multiple values

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

DouweMeer Member
Member

Re: Easy way to find multiple values

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

 

Untitled.png

 

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
Not applicable

Re: Easy way to find multiple values

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 Member
Member

Re: Easy way to find multiple values

@Anonymous 

 

Sadly enough that is not the case.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors