NULL value in chart dimension

ToniKautto — Tue, 10 May 2022 19:25:39 GMT

Chart object can get an unexpected NULL value in the dimension, even though there is no Null value in the loaded data.

The loaded data does not contain Null values. The expected result is that the chart reflects the loaded data.

Environment:

The NULL value can be visualized by disabling or unchecking any suppression of Null or Missing values.

Chart Properties > Dimensions > Settings for Selected Dimension > Suppress When Value Is Null
Chart Properties > Presentation > Suppress Zero-Values
Chart Properties > Presentation > Suppress Missing

The data model reveals that there is a connection from the data table over which the chart is calculated. In this case the Store table has a link to the Fruits table.

The key field details in the Store table show that only a 25% of the values in Fruit are used in the Store table.

The data used for the chart calculation will include also a representation of the unused key field values. The chart calculation is based on data that looks like the below image. When the key field is removed there is still a Null representation in the Sales and SalesPerson field as an indication of the subset ratio, as highlighted in within the red square.

The data set used for the chart calculation will therefore have a Null value in the SalesPerson field, and if expanded in the chart the Null value can be seen.

Resolution:

There are two main approaches to visually remove the Null value from the chart.

In a chart object the Null value dimension can be suppressing Missing values.
Chart Properties > Presentation > Suppress Missing
Generate a data model where there is a 100% subset ratio within the data that is calculated.

article NULL value in chart dimension in Official Support Articles

NULL value in chart dimension

Environment:

Resolution: