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.
Advocate IThis is insane.
Why the hell would this not work in the way everyone in the known universe (except for the power BI UX designers) expects it to work?
What if i want to filter a table on a value that might not exist on the table currently, but could if the criteria was right? It won't exist in the basic filter list. But if the UI was written in some even mildly sensible way, I could enter it into the advanced filtering to filter it if and when it does occur.
its sh*t like this that makes me look more longingly towards other BI products on an almost daily basis recently
I just want an easy and out of the box way to do simple OR filtering. Created On > 01/01/2024 OR Status = Complete. I can't find any way to do this without code or a long-winded data manipulation. 😞
