# Missing Value Handling

Missing Value Handling is available in the following charts.

* Bar
* Line
* Area
* Pie / Ring
* Histogram
* Density Plot
* Boxplot
* Violin Plot
* Error bar
* Error Bar (Summarized Data)
* Map - Long/Lat
* Pivot Table
* Summarize Table

## Show Unused Factor Levels

You can set to show or hide the unused factor levels.

## Missing Value Hanling

### Type

You can set how to fill the missing value at the "Missing Value Handling" option. This option is available in the following chart types.

* Bar - Y-Axis
* Line - Y-Axis
* Area - Y-Axis
* Scatter (With Aggregation) - Y-Axis
* Pivot Table - Value
* Summarize Table - Value

The following options are available.

* None
* Fill with NA
* Fill with Zero
* Fill with Previous Value First, then Next Value (Only available in Pivot Table and Summarize Table)
* Fill with Previous Value
* Fill with Next Value
* Fill with Next Value First, then Previous Value (Only available in Pivot Table and Summarize Table)

Here are examples of how each option works. Suppose you have Sales data but it misses the data for year 2013 except USCA.

#### None

No filling happens. If you use a Line chart, It just connects the values. This is the default behavior.

![](/files/-MiZRigahze92b_N_L0L)

#### Fill with NA

It fills missing values with NAs. If you use a Line chart, lines will be intermittent.

![](/files/-MiZRigftkNqsfn2FQPi)

#### Fill with Zero

It fills missing values with zeros.

![](/files/-MiZRigi5ePtoVQaSUQp)

#### Fill with Previous Value

It fills missing values with the previous values.

![](/files/-MiZRigkiTNNMWmQOk3C)

#### Fill with Next Value

It fills missing values with the next values.

![](/files/-MiZRignTP8EuuhSNAZv)

### Direction

You can select the direction how you fill the missing values. The following options are available. This option is available only in Pivot Table and Summarize Table.

* All (Down then Across) ![](/files/S6tpPyet08UQkdhWw6Oi)
* Row (Across) ![](/files/tm7opb9JOwHAoeQxkwUD)
* Column (Down) ![](/files/wbWb6YD7pfLL4V5ptULK)
* Column (Down within Group) ![](/files/v0QnDkqukjwB7pbrFw2Z)
* Column (Down then Across within Group) ![](/files/FR1xgJtj4R9WUKMYjS2V)

### Range to Fill Through

For the "Fill with Previous Value" and "Fill with Next Value" options, you have the "Range to Fill Through" option. The following options are available.

* End of Each Group - Value filling happens within each group (Color and Repeat By) range.
* End of All - Value filling happens for the whole data range.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.exploratory.io/visualization/features/missing-value-handling.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.