Suppress Zero Values in Bar Chart

[anushree1]

Hi,

I would like to know if there is a way to ensure that the bars having zero values be made invisible .

I do understand by converting the zero to Null we can have this achieved, but i would want to retain the zero Values as it is required for me to go ahead with the other column calculations using the previously calculated values

[vinieme12]

Try by giving a decimal value to the Zero's

example

if( Sum(Sales)=0,0.01,Sum(Sales))

[anushree1]

Hi Vineeth,

The requirement is not to see those bars so this would not work

[vinieme12]

it will only be visible if you scale is in 2 decimals IS IT??