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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
KevinSGoff
Helper I
Helper I

Visual Filter to allow a user to paste in many values

I know there is a PBI visual called "Filter by List" from DevScope - but I've see comments about it being a paid visual.

 

Here's what I hoping to find: on my Filters page, I have a dropdown for many values  (let's say they are Product SKUs)

If a user has a list of a dozen specific SKUs, it's a bit of a pain to use the regular filter visual dropdown to search them.

But if they could copy-paste the values into a visual that's tied to the column, they could easily filter.

 

Like I said, I believe "Filter by List" does this, but I wanted to either verify that there's a free visual out there (or if someone is currently using "Filter by List" and can verify they are happy with it, and there's no paid licensing)

 

Thanks,

Kevin

 

 

 

4 REPLIES 4
v-dineshya
Community Support
Community Support

Hi @KevinSGoff ,

Thank you for reaching out to the Microsoft Community Forum.

 

Power BI visual that allows users to paste in many values such as a list of SKUs to filter a report efficiently. You are specifically mentioned the "Filter by List" custom visual from DevScope is free or paid.

Please refer the "Filter by List" custom visual from DevScope link. It contains the free version and paid version features.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/devscope-1156626.filterbylist

Please refer below free alternatives to "Filter by List"

1.  Use slicers across pages and sync them. Combine with DAX logic to simulate bulk filtering. This is  free but less user-friendly for large lists.

 

2. Create a parameter table where users can paste values into a column. Use relationships or DAX to filter visuals based on this table.

 

Note: If you have huge lists, better to choose Paid version of "Filter by List" visual.  otherwise you can choose above two options.

 

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

 

 

Hi @KevinSGoff  ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

 

Thank you.

Poojara_D12
Super User
Super User

Hi @KevinSGoff 

You're absolutely right—"Filter by List" from DevScope is a popular Power BI visual designed specifically for scenarios like yours, where users need to filter by a list of values (e.g., a list of SKUs) and want to copy-paste them all at once instead of using the standard slicer dropdown or search box. It enhances usability for reports dealing with long or complex lists. However, it’s important to note that "Filter by List" is a certified but paid visual—DevScope offers it as part of their Business Intelligence suite, and while it may be free to try, continued use typically requires a license after a trial period.

As of now, there’s no fully free visual in AppSource that offers the same paste-and-filter functionality at the same level of usability. A few workarounds exist, such as creating a parameter table with user input through Power Apps integration or custom visuals, but those methods are less intuitive and require more setup.

Many users who adopt "Filter by List" report that it works well and is worth the cost for business users who frequently filter by multiple values, especially in operational or SKU-heavy environments. If you’re not ready to invest, one alternative could be setting up a report page where users can upload an Excel or CSV file containing their list of SKUs and join that table to your data model—but that’s more technical and doesn’t offer the seamless copy-paste experience.

In short, if ease of use and efficiency are your goals and you frequently deal with filtering large lists of identifiers, “Filter by List” is likely worth the investment, and there’s no truly equivalent free visual currently available.

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Nasif_Azam
Solution Sage
Solution Sage

Hey @KevinSGoff ,

You’re right that the "Filter by List" visual from DevScope allows for pasting multiple values, which is a handy feature for scenarios like yours where users need to filter by a list of values such as SKUs. However, as you mentioned, it is a paid visual.

 

As for free alternatives, I’m not aware of an exact match for this feature in free visuals. That said, Power BI's default slicers do allow for selecting multiple values from a dropdown, but they don't have the paste-in functionality out of the box. One workaround could be using a Text Filter with custom DAX, where users can paste in their list of values (comma-separated), and the measure can filter the data accordingly.

 

If you’re willing to explore custom solutions, Power BI also supports custom visuals built using JavaScript, which could be tailored to handle copy-pasting.

In summary:

  • "Filter by List" is a good option but requires licensing.

  • A free alternative is using a combination of slicers and custom DAX or exploring custom visual options.

 

For Detailed Information:

Power BI Custom Visuals Documentation

Filter by List Visual by DevScope

Using Slicers in Power BI

Power BI DAX Functions

 

 

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.


Best Regards,
Nasif Azam

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.