Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create an advanced filter with more than 2 options

Hello,   the advanced filter allows to create a filter on an text attribute, specifing start by AAA or Start by BBB but, what if i want 4 options? The PBI Interface doesn't allow to add conditions...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    Anonymous -

    Oh that is interesting...

     

    For me if I went directly to Advanced filtering I was only shown two criteria like what your're experiencing. However, if you start with Basic filtering and then select the values for your criteria and then select Advanced filtering those criteria show.

     

    I didn't expect that. I figured you would have to write the logic in your DAX.

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
3 years ago

Looks like it did change, yes.  No longer works for me either.

LinLinB's avatar
LinLinB
Icon for Advocate I rankAdvocate I
3 years ago

I tried a few things. I FINALLY got it to work. You have to drag the field you would like to filter by TWICE into the filter column. So the first instance stays unfiltered (being used by the viz directly in some way).

The second instance is the one you can modify for multiple Advanced Filtering and numerous cases. I hope this helps.