How have a fixed show of dimension also without value

[pascos88]

Hello,

I need to have the x axes (Dimension) fixed also I don't have value for the component of the dimension.

Like the picture that I attached, but in the picture, I put a really small value if the value is 0

if(value>0,value,0.00001).

But this can't help me, because whan I have value per each turbine = 0, I have all bar with this value (I will have a normal chart) and also in the legend I have a point more.

Thanks for any  help

Pasquale

[luciancotea]

Uncheck Chart Properties -> Presentation -> Suppress Zero-Values

[pascos88]

Hi Lucian thanks for the response.

The problem is that sometime I don't have any kind of value, even Zero.

Is like some turbine sometime are without value.

Can you help me?

thanks

[MayilVahanan]

Hi

Try like this

If(IsNull(Value) or Len(Value) = 0, 0, Value)

or

=Alt(Value, 0)

Uncheck Chart Properties -> Presentation -> Suppress Zero-Values

Hope it helps

[luciancotea · Accepted solution]

Uncheck Chart Properties -> Presentation -> Suppress Missing