Oscar Broekman on 10 Oct 2015 01:40:00
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
- Comments (19)
RE: More than 2 values for advanced filtering
It's possible to get around this: https://codeover.io/powerbi-advanced-filters-creating-more-than-2-options/
RE: More than 2 values for advanced filtering
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.
RE: More than 2 values for advanced filtering
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
RE: More than 2 values for advanced filtering
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
RE: More than 2 values for advanced filtering
"Advanced" filtering is an oxymoron when i have to go to Basic Filtering and work through a list of 200+ items
RE: More than 2 values for advanced filtering
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....)
RE: More than 2 values for advanced filtering
Please add something like the "IN (var1, var2, .....)" syntax from SQL
RE: More than 2 values for advanced filtering
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.
RE: More than 2 values for advanced filtering
Yes, and also arbitrary logic (AND, OR, NOT) the way it works in Salesforce :-)