Forum Discussion

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago

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?

Tips and Tricks

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

    • DouweMeer's avatar
      DouweMeer
      Icon for Impactful Individual rankImpactful Individual
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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!