Suppress zeroes NUX on Column Chart

JoannaAn
Contributor

Suppress zeroes NUX on Column Chart

Hi!

A question - can I suppress zeroes when I'm using a Column chart?

I saw that option in Waterfall.. but I guess it is the only one where I can do it?

And no options about handling Zeroes in other types of charts?

 

Thank you.

 

2 REPLIES 2
fabien.junod
Certified Master Anaplanner

Re: Suppress zeroes NUX on Column Chart

Hello @JoannaAn 

Can you show us an xample?

 

Have you tried setting to zero format to Blank?

fabienjunod_0-1638976363735.png

Another option is to set a filter to hide items with value 0 from the chart

 

ChrisAHeathcote
Community Boss

Re: Suppress zeroes NUX on Column Chart

@JoannaAn 

You can try using an IF THEN ELSE statement in you data to return DIVIDE(0,0) if the data is a zero this will return a NA for all zeros which will not show on the final chart. 

If you need to display this data in a grid on a page create a duplicate module and use this IF THEN ELSE and use this duplicate grid to feed your chart. 

Chris
HeathcoteAndHerran.com