# Replacing Missing Values with Zeros

> If your data includes null values associated with a date, this can lead to gaps in widgets that are based on Cartesian charts. You can replace the missing values (Null) with zeros to create a continuous data flow.

*Source: https://docs.sisense.com/main/SisenseLinux/replacing-missing-values-with-zeros.htm*

---

Last updated: June 11, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

If your data includes null values associated with a date, this can lead to gaps in widgets that are based on
Cartesian charts.

![8 6continuouschart1thumb](https://docs.sisense.com/main/Resources/Images/8-6continuouschart1thumb0300.png)

You can replace the missing values (Null) with zeros to create a continuous data flow.

![8 6continuouschart2thumb](https://docs.sisense.com/main/Resources/Images/8-6continuouschart2thumb0300.png)

For example, if your chart begins in January and ends in December, but there is no value for October, you can choose
to include the missing date on the x-axis. You can also choose whether to continue the graph (create zero values) or
cut the graph where there are missing values.

**To replace null values as zeros:**

1. Create or edit a widget that is based on a Cartesian chart.
2. Add data to your widget.
3. In the Values panel, click the menu and select **Display Missing Values as Zeros**.
     
   ![8 6displayzero](https://docs.sisense.com/main/Resources/Images/8-6displayzero.png)
4. Click **Apply** to save the changes to your widgets.