OBIEE Showing zero's in a bargraph

Somebody asked me how you can show zero's (0) in a bargraph. Have a look at this table:

If you put this in a normal barchart you get:

For product 13 and 14 it i'sn't clear if the data is missing (NULL) or is zero (0). One way of making it visible is this: Add an extra column which only shows the zero's (case when...):

(In the final report you can hide it)

Covert your chart to a bar/line type:

Sync the axis:

Supress the line and set the symbol:

Have a look at the results:

Till Next Time