Dealing with Null Values in a Chart
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.
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.
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.
Hope I was able to explain to some extent. feedback and suggestions are always welcome.