Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bar Chart Columns Visibility

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

QV Question.PNG

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.

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

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

View solution in original post

2 Replies
sunny_talwar

May be this

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

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

Anonymous
Not applicable
Author

Awesome!!! worked perfect.

QV Answer.PNGThen in presentation I unchecked "suppress Zero-values" and checked Zero on bars so I can have this: