Issue in combo chart while shoiwng negative values using Axes

[#1]

Hello,

I need one help.

I am having one issue while I am trying to show the bar negative and positive values using Chart Axes property (Scale Static Min and Static Max). I have given functionality to user where user can select the Axes range from slider and it will show the data based on the axes limit set by user. I have created sample file with I put static Min and Static max value in charts . for Only Positive chart it is showing only positive bars but for negative it is showing both. So is there any way we can show only negative bars without make any changes in expression. The reason is I am using dynamic and multiple selection of dimensions.

Thanks in Advance.

[Gysbert_Wassenaar]

Click on the + in front of the expression, choose Background Color and enter an expression to make the bar transparent if its value is larger or equal to 0:

[HirisH_V7]

Hi,

May be like this,

=If(sum(Value)<0,Sum(Value))

By taking the values which are than  less than zero,

Hope this helps,

PFA,

Hirish