Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Search/Filter multiple records at once

Hi, 

 

I have a table with over a million unique IDs, what I would like to do is filter the table by multiple IDs at once by copying and paste the IDs into a slicer / search visual.

 

Is this possible?

 

 

Need Help
Tips and Tricks

2 Replies

  • shill1000's avatar
    shill1000
    Icon for Helper IV rankHelper IV
    9 years ago

    I don't believe it is. You are better off having your criteria in a file that gets updated, create a query from the file and then merge that with the base query. use the merge function with an inner join so it only returns the records in the base query that match the criteria query/file.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    Can you group the IDs? If you can, you can filter them by group IDs. 

     

    Best Regards!

    Dale