# Waterfall Chart

The Waterfall Chart in the KPI tool provides a clear and effective way to visualize incremental changes in a value over time or across categories. By using a combination of rising and falling bars, this highly customizable chart helps users track the impact of positive and negative contributions on a total value. Below is a detailed guide to its features and settings.

<figure><img src="/files/EnuHouhjqjDsex9O6jcz" alt="" width="408"><figcaption></figcaption></figure>

Here's a quick guide to create Waterfall Chart in KPI:

<figure><img src="/files/f03rXVk3cLntXS8J54yD" alt=""><figcaption><p>Adding Waterfall Chart in KPI by Powerviz</p></figcaption></figure>

## Data Tab&#x20;

**Value**  - Select the field representing the values for the chart.&#x20;

**Category** - Choose the category to group and display values.

<figure><img src="/files/ybqwlhMaZQT7AHfdzeg4" alt="" width="282"><figcaption></figcaption></figure>

## Waterfall Tab&#x20;

#### Orientation

<figure><img src="/files/Mqz3MWO16RLspsTLJ41A" alt="" width="221"><figcaption></figcaption></figure>

* **Vertical**: Displays the chart in a vertical layout.
* **Horizontal**: Displays the chart in a horizontal layout.

#### Bars

<figure><img src="/files/d6vynDp9hCPu5r2Jxq4D" alt="" width="225"><figcaption></figcaption></figure>

* **Increase Color with** [**Conditional Formatting**](/powerviz/kpi/edit-mode-introduction/kpi-charts/conditional-formatting.md): Define the color for bars representing increases, with optional dynamic formatting.
* **Decrease Color with** [**Conditional Formatting**](/powerviz/kpi/edit-mode-introduction/kpi-charts/conditional-formatting.md): Set the color for bars representing decreases, with dynamic formatting options.
* **Gradient Fill Toggle On/Off**: Enable or disable gradient coloring for the bars.
* **Min Color with** [**Conditional Formatting**](/powerviz/kpi/edit-mode-introduction/kpi-charts/conditional-formatting.md): Define the color for the smallest bars dynamically.

#### Bar Pattern

Choose the style for the bars:

* **Solid**: Full-color fill.
* **Outline**: Bars with outlines only.
* **Hatched**: Bars with a hatched pattern.

#### Connector Line Style

* **Style Options**: Choose how the connector lines between bars are displayed:
  * **Plain**: Solid line.
  * **Dashed**: Dashed line.
  * **Dotted**: Dotted line.
* **Width**: Adjust the thickness of the connector lines.
* **Color**: Set the color for the connector lines.

#### Total Bar

<figure><img src="/files/bzQCcFRfghx04bhNYgac" alt="" width="275"><figcaption></figcaption></figure>

* **Show Total Bar Toggle On/Off**: Enable or disable the display of a total bar.
* **Title**: Enter a label for the total bar.
* **Total Bar Color with** [**Conditional Formatting**](/powerviz/kpi/edit-mode-introduction/kpi-charts/conditional-formatting.md): Define the color for the total bar dynamically.
* **Gradient Fill Toggle On/Off**: Enable or disable gradient coloring for the total bar.
* **Min Color with** [**Conditional Formatting**](/powerviz/kpi/edit-mode-introduction/kpi-charts/conditional-formatting.md): Define the minimum color dynamically.
* **Total Bar Pattern**:
  * **Solid**: Full-color fill.
  * **Outline**: Bars with outlines only.
  * **Hatched**: Bars with a hatched pattern.

## Intermediate Summary (Inter. Sum)

<figure><img src="/files/supwUarFNnvJUsiFUDZ6" alt="" width="279"><figcaption></figcaption></figure>

* **Add Layer Button**: Add an intermediate summary layer to your chart.
* **Text**: Add custom text to the intermediate summary.
* **Index**: Specify the position of the intermediate summary.
  * **Note**: Index positions start from ‘0’.

<figure><img src="/files/xxwZHBw7oqtPHlOcj5F4" alt="" width="281"><figcaption></figcaption></figure>

* **Color with Conditional Formatting**: Define dynamic coloring for intermediate summary bars.
* **Bar Pattern**: Choose from the following styles:
  * **Solid**: Full-color fill.
  * **Outline**: Bars with outlines only.
  * **Hatched**: Bars with a hatched pattern.

## Format Tab

<figure><img src="/files/oPM5B7ZDH89qgxIjS1Td" alt="" width="308"><figcaption></figcaption></figure>

Click [here ](/powerviz/kpi/edit-mode-introduction/kpi-charts/format-tab.md)to explore the Format tab in detail. Explore customization options to modify ranking settings, adjust axis properties, configure gridlines, and fine-tune number formatting to meet your needs. Dive into each section to unlock advanced styling and formatting possibilities.

***

## Actions Tab&#x20;

The Action settings allow you to define interactivity within your report for all visuals. This feature lets you enable or disable cross-filtering capabilities, giving you control over how the visual interacts with others.

<figure><img src="/files/bpU0AsPv7T3L1TMZGjXS" alt="" width="282"><figcaption></figcaption></figure>

#### Action Options

* **None**:
  * Disables interactivity for the selected visual.
  * When selected, interacting with the visual will not impact or filter other visuals in your report.
* **Cross Filtering**:
  * Enables cross-filtering functionality.
  * Interacting with the visual will dynamically filter related visuals, allowing you to analyze specific data points or categories more effectively.

***

## General tab

<figure><img src="/files/xzqJc5AuvP0E062CQXKR" alt="" width="309"><figcaption></figcaption></figure>

This is common tab for all visuals click [here ](/powerviz/kpi/edit-mode-introduction/kpi-charts/general-tab.md)to explore settings. You can adjust visual properties, manage formatting options, and fine-tune various features to align with your requirements. Make sure to explore each section for a complete configuration.


---

# 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.powerviz.ai/powerviz/kpi/edit-mode-introduction/kpi-charts/waterfall-chart.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.