Forum Discussion
Create an advanced filter with more than 2 options
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.
Resident RockstarAnonymous -
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.
Hello ChrisMendoza ,
you are right! :D
This is almost funny, because imagine you have a long list with
AAAsometext1
AAAsometext2
AAAsometext3
...
AAAsometextn
You can select 4 choices as is AAAsometextX, and then, in the advanced filtering, change to contain and change the strings for AAA, BBB, CCC and DDD :D:D
Regards