56
Allow me to specify OR conditions across fields in filters. For example "Where sales > 10000 OR where name = 'UK'"
STATUS DETAILS
Under Review

Comments

P

The OR filter and the Nesting functions are much needed, especially when looking into complex relations in data.

P

In addition to having the option of OR'ing and/or AND'ing various filters together, I wish Power BI supported the usage of parentheses () to group them together. For example: Where ( Diagnosis IN ('1234','2468') And Category = 1 ) OR (Diagnosis IN ('9876','3333') And Category IN (5,6) ). This is a simple example of complexity - there are lots of more complex queries we wish we could support. Or, maybe this could be accomplished if Power BI allowed us to pass in the equivalent SQL Where clause; it could be a separate editable text area for the Where (Filter) expression. And just like with DAX expressions, Power BI would only allow it if it passes validation.

P

use "||" in place of "OR"