Forum Discussion

schaefws's avatar
schaefws
Frequent Visitor
6 years ago

Suppressing $0 Columns in Waterfall Chart

I have a waterfall chart that displays all of the correct data and it's working as intended...except that I am unable to suppress columns that are 0 value.  Is there any way to suppress those columns showing 0? I am using the standard waterfall chart published by Microsoft.

 

  

4 Replies

    • schaefws's avatar
      schaefws
      Frequent Visitor

      amitchandak 

       

      I've tried the visual level filter with no success.  I have tried edit interactions and that doesn't seem to do the trick either.  I have included some pictures in another reply - somehow wasnt able to in this post.

       

      The table I have set up does not have any $0 values in the CPU column.  The way I thought the Waterfall chart worked is that in the summarizes in the blue bars by my buckets called milestone and then calculates the delts for each milestone in the in-between bars on my break down, which I have as cost Category.  Isn't the implication here that doing a visual filter would just filter our the cost categories that have $0 on the row, but not the ones that have the same value in the compared milestones?  How do I make the bars go away for those values that are unchanged between milestone?