Avoid Nullvalues in Chart

Hello Everyone,

I found lot of queries being asked that Charts not displaying properly when have null values against then in the measure values. So thought of sharing my past experience that I had. below id the simple raw data that we will be using against the Line Chart.

Month	Sales
Jan	100
Feb
Mar	250
Apr	50
May	75
Jun	375
Jul
Aug	66

So we can see that we have null values for the Sales in the month of Feb and Jul. Now we will create a simple line chart against the Raw data and you can spot that on below chart we have a break in the line in the month of Feb and Jul which is not what we want.

So I created another measure using sales and added up 0 to it so as to handle the null value.

[Test]=[Sales]+0

The below chart is created with the newly created measure and you can see that now we are getting the chart way we want it.