Waterfall Chart
Last updated
Last updated
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.
Here's a quick guide to create Waterfall Chart in KPI:
Value - Select the field representing the values for the chart.
Category - Choose the category to group and display values.
Vertical: Displays the chart in a vertical layout.
Horizontal: Displays the chart in a horizontal layout.
Increase Color with Conditional Formatting: Define the color for bars representing increases, with optional dynamic formatting.
Decrease Color with Conditional Formatting: 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: Define the color for the smallest bars dynamically.
Choose the style for the bars:
Solid: Full-color fill.
Outline: Bars with outlines only.
Hatched: Bars with a hatched pattern.
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.
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: 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: Define the minimum color dynamically.
Total Bar Pattern:
Solid: Full-color fill.
Outline: Bars with outlines only.
Hatched: Bars with a hatched pattern.
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’.
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.
Click here 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.
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.
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.
This is common tab for all visuals click here 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.
