Don't display data when = 0

[charlotte_garnier]

Hi Community !

See in the picture bellow, I have a chart with several different pieces of data and I set one of them to be displayed as a robot icon. The thing is at one point, the data represented by my robot reaches 0. Then, what I'd like to have on my graph would be : robots when I have data to materialize and nothing when the value is 0. 

What I've tried to do with conditions erased the entire robots line and that's not wanted.

Thanks in advance !

[Lisa_Sun · Accepted solution]

To do this, you can set the zero value to NULL.  For instance,  

if(Sum(sales)=0, NULL(),Sum(sales))

Then for the dimension, select the option "Include null Value".

For the measure, select "Include Zero Value" 

Please find the example qvf.