Force chart to show where Measure = 0

[JustinDallas]

Hello Folks,

I have a bar chart which works fine, except for when my measure equals zero.  In these cases, the bar chart doesn't show the name of the dimension, but instead throws away the data point altogether.

For instance, I have an OnTime Delivery % measure which looks like so:

1-
count( [Late Delivery])
/
(count({$<[AgeBucketDRP]=>}[Ontime Delivery])+ count({$<[AgeBucketDRP]=>}[Late Delivery]))

This works, until you run into a selection grouping that has 1 delivery that was late (1 - (1 /( 0 + 1)) => 0.  How can I force my chart to show the zero valued measures?

Any help is greatly appreciated.

[sunny_talwar · Accepted solution]

Have you checked 'Include zero values' under Add-Ons -> Data handling?

[JustinDallas]

Sigh...thanks Sunny...

[pabloviera]

EDIT: sorry dismiss my message as it's not exactly your case. Regards.

A workaround people usually recommend in cases like this one is adding something like this:

+(0*count({1}[Late Delivery])) 

It should show the dimension even when there are no possible values.

[analyticsuser]

Hello,

 I'm having trouble to display 0 in the bar chart even when 'Include zero values' is selected in Data Handling property. Please help!