How to hide zero’s in series values on a graph?
Sometimes we want to use a graph with labels showing series values. Some values can be 0's displayed by Strategy automatically. However, these might not be expected to be visible and choosing the option "Hide null/zero toggle behavior" in Properties and Formatting does not bring any results.
To show series values on a graph choose Format > Format > Series Values and tick the option 'Show' (in Editable Mode).
The default graph will display 0's:
Solution:
The way to hide unwanted 0's is converting values from zero to null while building metrics.
Navigate to: Functions and Operations > Functions > Null/Zero
There is a function 'ZeroToNull' which should be added to every metric with the potential 0's on a graph.
The graph with zero to null conversion:
KB441620
