如何移除SSRS折线图中空值对应的零值线段？

Hey there, let's sort out that frustrating line drop in your SSRS line chart! I’ve dealt with this exact issue before, so here are actionable steps to get your chart matching your target screenshot:

1. Fix the EmptyPoints Property (Your Key Fix) #

You mentioned setting EmptyPoints=Zero—but that’s actually why the line is dropping to zero! That property replaces null values with zero. To create a gap (and skip the null points entirely), you need to set it to Gap instead:

• Right-click your line series in the chart → Select Series Properties
• Navigate to the Custom Attributes tab
• Find the EmptyPoints field and change its value to Gap

This will make the line stop at the last valid point before the nulls and resume after them, instead of dipping to zero.

2. Confirm Your Dataset Returns True NULL Values #

Sometimes what looks like a null is actually an empty string, zero, or a placeholder. Double-check your query to ensure the 38/39 point values are truly NULL. If they’re zeros instead, use an expression in your chart’s value field to convert them to NULL:

=IIF(Fields!YourDataValue.Value = 0, Nothing, Fields!YourDataValue.Value)

This ensures SSRS recognizes those points as empty and applies your EmptyPoints setting correctly.

3. Adjust the Value Axis to Avoid Forcing Zero #

If your value axis is set to start at zero, it can make the gap look like a drop even with EmptyPoints=Gap. Fix this:

• Right-click the value axis → Axis Properties
• Go to the Axis Options tab
• Set Minimum to Auto instead of a fixed zero value
  This lets the axis adjust to your actual data range, making the gap in the line more visible.

4. Filter Out NULLs (If You Don’t Need Those Categories) #

If you don’t want the 38/39 categories on your x-axis at all, filter them out:

• In your dataset query: Add a WHERE YourDataValue IS NOT NULL clause
• Or in the chart: Right-click the chart → Chart Properties → Filters → Add a filter where YourDataValue is not equal to Nothing

Give these steps a shot—changing EmptyPoints to Gap should resolve the issue for you. If you still run into trouble, feel free to share more details about your dataset structure or chart settings, and we can dig deeper!

内容的提问来源于stack exchange，提问作者User5590