Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
FYI, I submitted an Idea for this here: Include "in" or "not in" options to "Advanced filtering"
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
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.
This is insane not to offer this basic feature... I simply use Qlik products which has this ability built in.
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.
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...
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.
It doesn't work now.
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?
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
13 | |
8 |
User | Count |
---|---|
50 | |
40 | |
32 | |
16 | |
13 |