Remove labels with empty/zero values in breakdown waterfall

[luissilver]

Hi all,

I am trying to use a waterfall with different breakdown per category. I'd like to know how can I remove/hide in the breakdown of a waterfall the labels with 0 or any other condition (i.e.. like Blank). I would like to do it without reducing the number of breakdowns because then, it shows "Others" and I don't want that.

Here is the waterfall. I'd like to hide the Test one with zero.

Here is the table:

Is it possible to do it? I had to put a value in Test/Big2 because If I don't, it will show in the waterfall a -100 drop in Big2.

I'm sorry if I wasn't clear enough. Thank you so much for all posible information could be provided of how to achieve this. 

[LoreaneG]

Hi, 

I have the exact same issue. Were you able to find a solution ? 

Thanks, 

Loreane

[Anonymous]

Same issue here. Would appreciate some help

[calerof]

Hi @luissilver ,

Select your chart, at the right, under the Visualizations pane, under Filters, in the Visual Filter Level, in value select "is not 0" AND "is not blank".

Cheers,

Fernando

[luissilver]

Thank you so much for the reply, nevertheless, it does not work with my current table/data.

I am actually trying to replicate a starting value in the waterfall and this is the way (my table) I found it could work. However, I am not able to hide the Test1.

Thank you again Fernando.