reporting-serviceslinechartreportbuilder

Empty values issue SSRS Report Builder chart

Click for image with line chart

enter image description here

Edit for clarity: I have empty values in my series. I want SSRS to draw a direct line between the existing data points. Empty values is set to "average" and results in the stepped lines shown in the image.

I want it to look like this: Same data charted in Excel

Here is my data click here

Original post:

I have a line chart with three series in Report Builder. Two of the series have null values between points. At first I could not get the lines to show at all, but after searching, I set the empty points color to match the series color. Now it is showing the lines but they are squiggly, not straight lines between each point.

I have searched the site but am unable to find a post with this exact issue.

Solution

  • This is a bit of an SSRS oddity. The solution is simple. You need to choose a colour for the "EmptyPoint" property of each series. I think this should be the default but there you have it..

    Click on the first series, then go to the properties pane (F4 from Visual Studio or View/Properties from Report Builder).

    Expand the "EmptyPoint" section and choose a colour.

    Repeat for each series.

    See below

    enter image description here

    Here's the final output.

    enter image description here

    For further into see the SSRS Documentation.

    Add empty points to a chart in a paginated report