> For the complete documentation index, see [llms.txt](https://docs.powerviz.ai/powerviz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powerviz.ai/powerviz/kpi/edit-mode-introduction/kpi-charts/waterfall-chart.md).

# 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.
