- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Advanced Filter
Greetings!
Is there a way to add a filter, select advanced filter, and use more than two qualifiers? I need to filter by a total of four codes and it appears to only allow two. For example, when filtering by manufacturer code, I need to select 062, 140, 439, and 853 as this particular manufacturer has multiple codes. Is this possible?
Your assistance is appreciated.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The way I worked around this was to create a lookup table by group representative name. Then I was able to sort this particular group as well as three others. I didn't really need to create a master list but it is the same idea.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear all, i found a solution to this problem, in the "Filters" pan, select "filters on this page" tab, rather then "filters on this visuals" this should solve the issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This "workaround" does seem to work in most cases, but doesn't work for Azure Analysis Services hierarchy fields. Voting for a real >2 advanced filters feature - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10144383-more-than-2-values-for-a...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi guys,
I found a much easier way to do this:
I have chosen Basic filtering, then selected all, then searched for each code and unselected it, at the end I got what I wanted.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I stumbled on a workaround for this limitation of two (2) Advanced Filters. First I determined the number of filters I needed to get the results I was looking for. In my case I needed 5 filters. Instead of choosing "Advanced Filtering", I chose "Basic Filtering" and then chose 5 random selections. I then switched the drop-down from "Basic Filtering" to "Advanced Filtering" again, and it presented me with 5 filters vs the default of 2. Be sure not to hit the "Apply" button until you have filled out all 5 of the filters because as soon as you hit apply, any filters that are left blank will dissappear.
Hope this helps....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is this still working?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Gotta say this worked very well and is probably the funniest UI workaround ever.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, this worked just fine for me. 6 filters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Worked like a treat, you've helped so much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Absolutely fantastic 👍 worked a treat, can't thank you enough for this great helpful hint 😊
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for the tip, worked like a charm
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wow this worked for me. It is truly so pathetic that you have to hack it this way for just a fundamental functionality.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I stumbled on a workaround for this limitation of two (2) Advanced Filters. First I determined the number of filters I needed to get the results I was looking for. In my case I needed 5 filters. Instead of choosing "Advanced Filtering", I chose "Basic Filtering" and then chose 5 random selections. I then switched the drop-down from "Basic Filtering" to "Advanced Filtering" again, and it presented me with 5 filters vs the default of 2. Be sure not to hit the "Apply" button until you have filled out all 5 of the filters because as soon as you hit apply, any filters that are left blank will dissappear.
Hope this helps....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is a great workaround. Exactly what I needed. Thanks for sharing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It's been one and a half years since this post, but I tried it today and it worked beautifully!
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Seems to be working. Awesome tip!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @kcantor, the way that I would solve this issue would be the following:
- If the codes are always going to be the same, I would go into the Query Editor.
- I would then create a new Custom Column or Conditional Column lets call it ManFactFilter
- In this Column I would then specify the codes with the output example being Manufacturer 1
- And the else clause being "Other Manufacturers
- I would then load this data into my Model.
- And then I would create a Slicer or in my filters drag in the ManFactFilter column, and then simply select Manufacturer 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The way I worked around this was to create a lookup table by group representative name. Then I was able to sort this particular group as well as three others. I didn't really need to create a master list but it is the same idea.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This may have already been solved, but as this thread doesn't have one already I thought I'd add what we do...
In the PowerBi Custom visuals page, there are two visuals we use that work well for multiple advanced filtering: The Attribute Slicer and the SmartFilter. Both of these will allow you to search for groupings based on values you select, and select multiple groupings to filter the page.
Keep in mind, this is great to bypass the 2 filter limit in the native program, but if you're looking to group anything more than 20 filters this can get tedious.
The link to the visuals page is https://app.powerbi.com/visuals/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
u can use if to get 2 values then u can use the if result to filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
unfortunately, only two values are available in the advanced filter. The old Power BI supported search in a list of values that was very convenient, but the PBI 2 does not support that anymore so you may have to do a lot of scrolling to multiselect your codes. Hopefully this experience will get enhanced soon.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-18-2024 07:27 AM | |||
11-13-2024 05:29 AM | |||
11-01-2024 07:28 AM | |||
Anonymous
| 10-08-2024 06:59 AM | ||
08-02-2024 02:11 AM |