Forum Discussion

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
11 years ago
Solved

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 fil...
Need Help
  • kcantor's avatar
    kcantor
    9 years ago

    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.

M_Rea's avatar
M_Rea
Frequent Visitor
9 years ago

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/