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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
vmazz77
New Member

How can I filter by a list of values?

We have the need to be able to filter by a list of values.  For example, we have a list of orders and would like to be able to paste the values into a filter for order numbers.  Is this possible in either Power BI or Power BI Desktop? 

 

I understand you can search for a particular value, filter for a contiguous range of values, or check individual values for filtering, but it doesn't seem possible to paste a list of values to filter on.

32 REPLIES 32
cathoms
Helper V
Helper V

FYI, I submitted an Idea for this here: Include "in" or "not in" options to "Advanced filtering" 

NorwaySasquatch
Advocate I
Advocate I

Just found out the way to do this. Use this slicer: Mass Filter (microsoft.com)

 

This slicer on say page 1 can only filter page 1. However, if theres 10 of them across each of the 10 pages, they all stay synced. So if we filter slicer #1 , #2-#9 also filter. The secret is to hide #2-#9 by putting them behind a visual, title etc. so users only see it on the slicer page

 

YosefF
New Member

One simple solution would be to create a new data table for the list of values you need. Link it to your main data table, and then you can add it as a filter in your visuals.

Robbro
New Member

This is insane not to offer this basic feature... I simply use Qlik products which has this ability built in. 

pedropaixao
New Member

Hey there!

 

I found a visual on market place called "Filter By List", it is a very simple visual that does exactly want we are try to solve here.

 

BR,

Pedro Paixão

Could you please send the link?

This is the visual - worked perfectly for me.

 

https://blog.pragmaticworks.com/power-bi-custom-visuals-filter-by-list

 

 

Not sure why we can't do this natively....

This visual seems to be discontinued by pragmatic works, has anybody found a replacement? I spoke to their support and they have no information on why its not longer available and dont plan to replace it.

Shelley
Continued Contributor
Continued Contributor

This Mass Filter appears to be the same custom visual and is on the app store and does sync across tabs!  Business Apps – Microsoft AppSource  https://appsource.microsoft.com/en-US/product/power-bi-visuals/insiderscoop1611244107840.powerbi_cus...

Shelley
Continued Contributor
Continued Contributor

If you're still looking for this functionality, I've discovered this custom slicer visual. It works. The limitation for me is that it doesn't sync across tabs and it is kind of large, but it comes in handy.

 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381413?tab=Overview

 

If this addresses your need, please consider marking this as a solution.

Anonymous
Not applicable

It doesn't work now.

Shelley
Continued Contributor
Continued Contributor

This Mass Filter appears to be the same custom visual and is on the app store and does sync across tabs!  Business Apps – Microsoft AppSource  https://appsource.microsoft.com/en-US/product/power-bi-visuals/insiderscoop1611244107840.powerbi_cus...

Hey. I am using this Mass Filter and would need to sync between tabs, but I can not figure out how. The built-in "Sync slicers" does not recognizes this visual and if I copy the visual PBI does not asks me if I would want to sync either. Can you help me how can I achieve this?

Shelley
Continued Contributor
Continued Contributor

Hello @ttypical , It appears the Mass filter no longer syncs across tabs. Try this one, Filter by List:  https://appsource.microsoft.com/en-us/product/power-bi-visuals/devscope-1156626.filterbylist?tab=ove...  

I use this one all the time, and it syncs across tabs. Have fun!

Note - filter by list recently went to a paid model and the sync across tabs feature no longer works. Huge downgrade in UI too. Hoping they revert their changes.

Really?? The paid version doesn't sync across tabs?? Are you sure? 

 

Was pushed out couple days ago. I tested the paid version and could not get it to sync across tabs anymore. The upgrade removed that functionality I guess.

Thanks. It just hit us today. If it doesn't sync across tabs, I might as well use the Mass Filter for the same functionality, but free. What a nightmare this is for us.

Same here - hit today and also a nightmare. I believe my idea above leveraging Mass Filter, and pasting it to each tab but hiding it behind visuals no longer works as well. It worked a month ago 😞 

Yes, I cannot get Mass Filter to sync across tabs either. So frustrating, not sure if this is developer issue or Microsoft, but ususally lots to blame on Microsoft for disruptions and unknown upgrades causing new bugs.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors