Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
      • Overview
      • Chart settings
      • Measure Values and Measure Names
      • Multi-dataset charts
        • Creating a chart
        • Replacing a dataset in a chart
        • Creating a multi-dataset chart
        • Adding a hierarchy
        • Configuring a navigator
        • Configuring the display of null values
        • Creating a color palette
    • Versioning
    • Chart inspector
    • Access management
  • Audit Trails events
  1. Charts
  2. Wizard charts
  3. Step-by-step guides
  4. Configuring the display of null values

Configuring the display of null values

Written by
Yandex Cloud
Updated at March 6, 2025

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 normalized).
  • Bar chart (including normalized).
  • Scatter chart

If the source data includes a row where the measure value is null, the chart with default settings connects the neighboring points with values other than null with a line.

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

  1. Click in the top-right corner of the section with the measure you want to configure (the icon appears on hover).

  2. Set up the Null values option:

    • Hide: Do not show points with null values. On the chart, it will appear as a line gap, skipped column or point. For example, the source has a row with a date (20.07.2022) but the sales total for it is not specified.

      Example of a chart with a gap

      image

      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
    • Connect: Connect neighboring points with values other than null with a line.

    • Display as 0: Replace null values with 0.

  3. Click Apply.

Example of replacing null with 0

image

If a row is missing from the source data altogether, 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 particular date (20.07.2022), nothing will be shown for this date on the chart.

Example of a chart with a missing date

image

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 null for value to the source.
2. In the chart settings for the relevant indicator, select Display as 0 for the Null values option.

Was the article helpful?

Previous
Configuring a navigator
Next
Creating a color palette
© 2025 Direct Cursus Technology L.L.C.