5 Replies Latest reply: Jun 30, 2017 8:12 AM by Partha Kulkarni

# Exclude zero value in Bar Chart

The site is not allowing me upload the image. I want to exclude the zero value in Bar Chart. Can anyone help in this regards?

CY - Sum({<Year = {'\$(=Max(Year))'}>} Sales)

LY - Sum({<Year = {'\$(=Max(Year)-1)'}>} Sales)

After applying

CY - if(Sum({<Year = {'\$(=Max(Year))'}>} Sales)>0,Sum({<Year = {'\$(=Max(Year))'}>} Sales))

LY - =if(Sum({<Year = {'\$(=Max(Year)-1)'}>} Sales)>0,Sum({<Year = {'\$(=Max(Year)-1)'}>} Sales),'')

• ###### Re: Exclude zero value in Bar Chart

Hi Ram

I hope this helps, I have a picture below.

• ###### Re: Exclude zero value in Bar Chart

I tried this for the first time . After that I used the third and fourth expression. Can you please go through the second image. It was done , but the space between 2015 and 2014 is high. Can anyone help in this regard?

• ###### Re: Exclude zero value in Bar Chart

You seem to have two dimensions and two expressions, is that right?

• ###### Re: Exclude zero value in Bar Chart

! dimension with 2 Measures, Sunny

• ###### Re: Exclude zero value in Bar Chart

HI Ram,

I dint get the use of if condition because your aggregated value will be greater than zero. So i doubt on working of if condition.

Can you share sample application?

Regards,

Partha K