More than 2 values for advanced filtering

[obroekma]

In Power BI Desktop, in 'Report Level Filters', we would like to be able to filter on more than just 2 values in advanced filtering

[fbcideas_migusr]

Yes, and also arbitrary logic (AND, OR, NOT) the way it works in Salesforce 🙂

[Maja2]

PBI Desktop and Service, and at any level filter; it would be nice to specify an "in list" of values as opposed to just 2. I have thousands of records (users) where I'd like to filter x number of them; not just 2.

[MAwbre]

Please add something like the "IN (var1, var2, .....)" syntax from SQL

[beppe1962]

Would be nice and really effective to have the same feature that are in the filter visual (like for example the lens option and dropdown menu....)

[richardq_onthew]

"Advanced" filtering is an oxymoron when i have to go to Basic Filtering and work through a list of 200+ items

[lwilkerson]

It would be nice to start with 1 value and then have an "add value" option that would allow the user to add as many as they need

[MAwbre]

There is a work-around, albeit it is pretty hacky. If you have a decent sized list under the "basic fitlering" option, you can purposefully select a number of those items. That will have power BI list the filter as something like: "X and Y and Z and ..." Then, with that filter turned on, swap to the advanced filtering. You will see an option representing each of the "and"s. You can then change those from "equals" to whatever advanced filter you want.

[gregory_guidar3]

Yes, please add support for "is in list" or "is not in list" so we can paste long list of values. There was another idea similar; in those comments, someone pasted this: https://ideas.powerbi.com/forums/265200-power-bi-ideas

[danielhorton]

It's possible to get around this: https://codeover.io/powerbi-advanced-filters-creating-more-than-2-options/

[clayton_webber]

If you know how many values you want to search start off in basic mode and select that #, then switch to Advanced. It creates all the filed for you..