Report Viewer Plotting

Is there any way to prevent the line graph component, on the report viewer, from plotting Nulls as 0’s? I have a set of data with a new data point for each day that I am plotting. On top of this I am plotting the 2 week moving average for the data. This moving average data has Nulls for the first 13 days and currently the line graph is plotting these as 0’s which misrepresents the data. Any help would be appreciated.


On the dataset that is fueling your report, you could add to your where clause so it throws out 0s and nulls.