SSRS Stacked Area and Line Chart showing Gap between Dates

Question

I have a line chart that is showing a series for the stack area. I have nulls for my data for a few months in a row which shows a gap in the chart which what I want a cliff. But when the chart resumes with non null data the chart starts from 0 and shoots up to the number lets say 98 in this case. How or which properties do I need to adjust in the chart that when I resume I can start off at 98 instead of 0 and climbing up to 98.

Answer 1

Rather than using a Stacked Area chart you could use a Stacked Column chart. For the data series you wish to be visible view the properties of the series, and under CustomAttributes set PointWidth to be 1.1.

When rendered this will then look like as below