Skip to content

Latest commit

 

History

History
54 lines (36 loc) · 3.07 KB

add-empty-points-to-a-chart-report-builder-and-ssrs.md

File metadata and controls

54 lines (36 loc) · 3.07 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Add empty points to a chart in a paginated report
Specify empty points on a chart in a paginated report. These points are calculated in Report Builder by taking the average of the previous and next data points that contain a value.
kfollis
kfollis
09/25/2024
reporting-services
report-design
how-to
updatefrequency5

Add empty points to a chart in a paginated report (Report Builder)

[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]

Null values are shown on the chart as empty spaces or gaps between data points in a series. In paginated reports, empty points are data points that can be inserted in the empty space created by null values.

By default, empty points are calculated by taking the average of the previous and next data points that contain a value. You can change this configuration so that all empty points are inserted at zero.

For more information, see Empty and null data points in charts (Report Builder).

Note

[!INCLUDEssRBRDDup]

Specify empty points on a chart

  1. Open the Properties pane.

  2. On the design surface, right-click the series that contains null values. The properties for the series are displayed in the Properties pane.

  3. Expand the EmptyPoint node.

  4. Select a color value for the Color property.

  5. In the EmptyPoint node, expand the Marker node.

  6. Select a marker type for the MarkerType property.

    [!NOTE]
    You must select a marker type to add empty points to a bar, column or scatter chart. However, for area, line and radar charts, selecting a marker type is optional because the chart fills in the empty space or gap without requiring a marker to be specified.

  7. Set the value of the empty point.

    1. In the Properties pane, expand the CustomAttributes node.

    2. Set the EmptyPointValue property. To insert empty points at an average of the previous and next data points, select Average. To insert empty points at zero, select Zero.

Related content