Hello,

I am using SSRS 2014  chart itss smooth line, there is a previous year sales line and a seperate current year sales line.  I am using week number as category for example from week 1 to 52, currently we are in week 34 for the previous year sales week 1 to week 52 is populated OK, but here is my problem we are in week 34 and the line will drop down to week 35 to zero and it will be zero to week 52.  I don't want the line dropping down to zero I just want it to stop at week 34.  How can I do that?  Thank you in advance.

I think that the problem may be in your query. Check your output of your query.