Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Remove labels with empty/zero values in breakdown waterfall

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. 

Need Help

4 Replies

  • calerof's avatar
    calerof
    Impactful Individual
    7 years ago

    Hi Anonymous ,

     

    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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Same issue here. Would appreciate some help

  • LoreaneG's avatar
    LoreaneG
    Frequent Visitor
    4 years ago

    Hi, 

     

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

     

    Thanks, 

     

    Loreane