Bar Chart - Bar for 0 value

[venkat_thota]

Hi,

I found this weird behavior in Bar Chart. When the value is zero then it shouldn't show the bar as the axis is 0. But its showing the Bar (Enclosed the screenshot). I understand the reason why because its a taking the decimal values. Though the data value showing as 0% , the actual value is 0.00476.  This creates confusion for users.

Is there any fix for it?

[mikaelsc]

Floor() your expression if you want 0.

if you want to show the actual value,increase decimals...

[jonathandienst]

Floor(your expression, 0.01)

or 

Round(your expression, 0.01)

[venkat_thota]

If I use round or floor function in expression, it gives wrong result, the percentage wont come correct. all I wanted to do is bar should be in sync with data value. 

If the expression returns 0.072, it should consider as 1% and the bar also should show accordingly.

If the expression returns 0.035, it should consider as 0% and the bar also shouldn't show.

if the expression returns 0.1245, it should consider as 13% and the bar should show accordingly.

My problem is data value is showing correct, but not the bar.