Configuring the display of null values
Note
The setting is only available for charts that have at least one X or Y axis:
- Line chart
- Area chart (Stacked and Normalized)
- Column chart (including a Normalized column chart)
- Bar chart (including a Normalized bar chart)
- Scatter chart
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.
Example of a chart with a gap
Source table
| OrderDate | Sales |
|---|---|
| 15.07.2022 | 301629 |
| 16.07.2022 | 453595 |
| 17.07.2022 | 977583 |
| 18.07.2022 | 527834 |
| 19.07.2022 | 870054 |
| 20.07.2022 | null |
| 21.07.2022 | 569650 |
| 22.07.2022 | 1116034 |
| 23.07.2022 | 883208 |
| 24.07.2022 | 2359483 |
| 25.07.2022 | 1137851 |
You can configure how the chart will display null values in the chart section settings:
-
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).
-
Specify a value for the Null values option:
- Ignore: Do not show points with
nullvalues. On the chart, it will appear as a line gap, skipped column or point. - Connect: Connect neighboring points with values other than
nullwith a line. - Display as 0: Replace
nullvalues with0.
- Ignore: Do not show points with
-
Click Apply.
Example of replacing null with 0
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.
Example of a chart with a missing date
Source table
| OrderDate | Sales |
|---|---|
| 15.07.2022 | 301629 |
| 16.07.2022 | 453595 |
| 17.07.2022 | 977583 |
| 18.07.2022 | 527834 |
| 19.07.2022 | 870054 |
| 21.07.2022 | 569650 |
| 22.07.2022 | 1116034 |
| 23.07.2022 | 883208 |
| 24.07.2022 | 2359483 |
| 25.07.2022 | 1137851 |
Note
To display a zero value for a date missing from the table:
1. Add a row with this date and a null value to the source.
2. In the chart settings for the relevant indicator, select Display as 0 for the Null values option.