Bar Chart Columns Visibility

[Anonymous]

Hello guys,

Currently I'm working in a new dashboard and I'm kind of blocked with a Bar Char property:

I have this expression in this chart:

(Sum({<Año = {$(vMaxYear)}>} Hl) / Sum({<Año = {$(=$(vMaxYear)-1)}>} Hl))-1

And I don't want to show the bars that are showing -100% due to the lack of data; for april 2018 I don't have any so the division is zero so I want to show it as a zero bar (or if there is another solution).

How can I do this?

Thank you very very much.

[sunny_talwar · Accepted solution]

May be this

If(Sum({<Año = {$(vMaxYear)}>} Hl) <> 0,

(Sum({<Año = {$(vMaxYear)}>} Hl) / Sum({<Año = {$(=$(vMaxYear)-1)}>} Hl))-1)

[Anonymous]

Awesome!!! worked perfect.

Then in presentation I unchecked "suppress Zero-values" and checked Zero on bars so I can have this: