Configuring the display of null values

If the source data includes a row where the measure value is null, the chart will not be built for that point at default settings (there will be a gap in the line, or column/point will be skipped). For example, if the source has a row with a date (20.07.2022) but the sales amount for it is missing.

You can configure how the chart will display null values in the chart section settings:

1. In the section with a measure whose values you want to show, in the top-right corner, click (the icon appears when you hover over the section).

2. Specify a value for the Null values option:

   • Ignore: Do not show points with null values. On the chart, it will appear as a line gap, skipped column or point.
   • Connect: Connect neighboring points with values other than null with a line.
   • Display as 0: Replace null values with 0.

3. Click Apply.

If a row is missing from the source data completely, the Null values option will not change the way the chart is presented. For example, if the source does not have a row with a certain date (20.07.2022), nothing will be shown for this date on the chart.