How to get blanks to show 0 in date visual

[JordanJackson]

I am looking to have the values show 0 on a line graph where there is no data for that period. Showing data with no values just leaves this space blank on the graph (See photo) 

I have seen a few videos talking about + 0 turning blanks in 0's. But I am unsure how do do this as my data is a date column.

Any help with this would be greatly appreciated as I am at a loss. 

Thanks

[JordanJackson]

But what would the expression be? The incident date column?

[Anonymous · Accepted solution]

HI @JordanJackson,

Did you use the measure formula on the chart? If that is the case, you can change your formula to add '+0' on the end. It will expand the calculation on all ranges and replace blank parts with zero.

If you are using a table column on the chart value field, you can write a measure formula with the aggregate of that field and add +0 to replace the raw table field of the visuals.

Regards,

Xiaoxin Sheng

[Anonymous]

measure = <expression> + 0