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.
Hi everyone,
this thread was created in 2019, and here we are 4 years later in 2023 with the same situation.
The solution of ChrisMendoza is obviously helpful, but to me, it just feels like a workaround. I expect better from a big company like Microsoft. It can't be that difficult to add a "+" (plus) button or something similar to add more options when using the Advanced filtering options, can it?!
- jdbuchanan71
Super User
Anonymous
You can vote for the feature in the ideas area here.
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=866ea64e-d078-47d0-8221-3db1a8209fbe
Hi jdbuchanan71 , Thanks, just did.
