Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
GREGBLACK
New Member

Mass Filter Upload

Hi all.
I have a cohort of users who use a report I built that contains milliosn of rows of data.
This data is based on transactions and accounts.
When using Tableau they have been able to copy and paste a list of transactiosn into the transaction filter with no issues.
i can't seem to be able to mirro this action on power bi without havign to create excel sharepoints etc--this is not a good use of their time as they need to act quickly when provided with a list of transactions.
Has anyone found a way to do this with Power BI?
Thanks
Greg

1 ACCEPTED SOLUTION
v-fenling-msft
Community Support
Community Support

Thanks for lbendlin and rohit1991's concern about this issue.

 

Hi, @GREGBLACK 

I am glad to help you.

 

Since you didn't give me some data to test, I assumed some data myself:

vfenlingmsft_1-1733118164382.png

 

There's a custom visual called "Mass Filter" available on AppSource. This visual allows you to copy and paste a list of values (separated by commas or new lines) directly into the filter:

vfenlingmsft_11-1733118949527.png

 

vfenlingmsft_9-1733118862162.png

 

vfenlingmsft_8-1733118695627.png

 

vfenlingmsft_0-1733118078650.png

 

 

You can also use a custom visual recommended by lbendlin : Filter by List Visual

vfenlingmsft_10-1733118910729.png

 

vfenlingmsft_7-1733118654376.png

 

vfenlingmsft_5-1733118424650.png

 

vfenlingmsft_3-1733118303493.png

 

I hope the above methods can help you!

 

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-fenling-msft
Community Support
Community Support

Thanks for lbendlin and rohit1991's concern about this issue.

 

Hi, @GREGBLACK 

I am glad to help you.

 

Since you didn't give me some data to test, I assumed some data myself:

vfenlingmsft_1-1733118164382.png

 

There's a custom visual called "Mass Filter" available on AppSource. This visual allows you to copy and paste a list of values (separated by commas or new lines) directly into the filter:

vfenlingmsft_11-1733118949527.png

 

vfenlingmsft_9-1733118862162.png

 

vfenlingmsft_8-1733118695627.png

 

vfenlingmsft_0-1733118078650.png

 

 

You can also use a custom visual recommended by lbendlin : Filter by List Visual

vfenlingmsft_10-1733118910729.png

 

vfenlingmsft_7-1733118654376.png

 

vfenlingmsft_5-1733118424650.png

 

vfenlingmsft_3-1733118303493.png

 

I hope the above methods can help you!

 

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thaanks v-fenling-msft.
I did stumble across this Mass Filter over the weekend myself and it seems to be fit for purpose.
Thanks again
Greg

rohit1991
Super User
Super User

Solution: Dynamic Filtering via a Parameter Table

  1. Enable User Input for Filtering:

    • Once loaded, the table will appear in your fields pane.
    • Go to the Data View, and manually add or modify transaction IDs as needed.
  2. Create a Relationship:

    • Connect the TransactionID_Input table to your main data table:
      • Drag the TransactionID_Input field to the TransactionID field in the transaction table.
      • Set the relationship to "Many-to-One" and Single Direction.
  3. Filter Visualization or Report:

    • Use the TransactionID_Input as a slicer or in the filter pane to allow filtering.
lbendlin
Super User
Super User

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Kudoed Authors