Suppress zero values on stacked bar chart

[pradnyat]

Hi All,

In dashboard we are showing one stack bar chart. We want to show only one stacked bar, hence we are using 2 dimensions : 1 and Dim2. and 1 expression Exp1.

There are 6 values for Dim2.

For 4 values of Dim2, Exp1 is coming above 0% and for other 2 its coming as 0%.

So basically in legends it should show only 4 values,  but it is displaying all 6 values.

I also checked the suppress 0 values option in presentation.

I want to suppress legends for which Exp1 is coming as 0%.

Is there any way to achieve this?

Thanks in Advance.

[Gysbert_Wassenaar]

Perhaps the 0% is not really 0, but a fraction that's close to, but not equal to zero. In that case you'll have to use the floor, ceil or round function to round the value to the appropriate number of digits.