Remove spaces with in Clustered bars in Chart

[chaper]

How to remove spaces with clustered bars in a bar chart.when I select the cluster (Dimension value)I dont see any spaces but without any selection I see gaps.See below.I tried bar cluster distance and bar distance and supressing nulls also.No luck

  

[sunny_talwar]

I don't think there is a way to remove them. What I usually do is use this as my expression:

=If(Len(Trim(yourExpression)) = 0, 0.0000001, yourExpression)

This forces a slight bar (removing the extra space) and when you put value on the chart it shows you 0 on top of it.

It's just a work around I have used lately, but I would be curious to know if there is a way to remove the extra space.

Best,

Sunny

[chaper]

Tried your expression.No luck

Thanks

[sunny_talwar]

Well like I said, it won't remove the empty space, it will just show a very small bar. It is not showing a very small bar? Can you share a screenshot of what it showed after you added the suggested expression?

Best,

Sunny