Exclude zero value in Bar Chart

[rammuthiah]

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),'')

[sibusiso90]

Hi Ram

I hope this helps, I have a picture below.

[rammuthiah]

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?

[sunny_talwar]

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

[rammuthiah]

! dimension with 2 Measures, Sunny

[parthakk]

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