Power BI Ideas Admin on 03 Oct 2014 07:09:48
Allow setting of the min and max value displayed on a visual's axes
Administrator on 13 Aug 2021 06:59:42
verfification
- Comments (12)
- Merged Idea (3)
RE: Control over axes ranges
The OR filter and the Nesting functions are much needed, especially when looking into complex relations in data.
RE: Control over axes ranges
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.
RE: Control over axes ranges
use "||" in place of "OR"