Waterfall charts in Power BI - Step-by-Step Guide

Introduction

Waterfall charts help you see how a starting value changes step-by-step to reach a final value. They show increases and decreases clearly, making it easy to understand how different parts add up or subtract from the total.

When you want to show how monthly sales grow or shrink from the start to the end of the year.

When you need to explain how expenses affect your profit step-by-step.

When you want to visualize changes in budget from one period to another.

When you want to break down the components that lead to a final number, like cash flow changes.

When you want to highlight positive and negative impacts in a financial report.

Steps

Step 1: Click

- Visualizations pane

The list of available chart types appears

Step 2: Select

- Waterfall chart icon in the Visualizations pane

A blank waterfall chart placeholder appears on the report canvas

Step 3: Drag

- Field from Fields pane to the 'Category' well in Visualizations pane

The chart shows categories on the horizontal axis

Step 4: Drag

- Numeric field (like Sales or Amount) to the 'Y axis' well

The chart displays bars representing increases and decreases for each category

Step 5: Click

- Format pane (paint roller icon)

Formatting options for the waterfall chart appear

Step 6: Adjust

- Data colors section in Format pane

Colors for increases, decreases, and totals update on the chart

💡 Use distinct colors for positive and negative changes to improve clarity

Before vs After

Before

Report canvas shows no visual or a blank placeholder

After

Waterfall chart displays bars showing step-by-step increases and decreases with category labels

Settings Reference

Data colors

📍 Format pane > Data colors

To visually distinguish positive, negative, and total values in the chart

Default: Blue for increase, red for decrease, gray for total

Category labels

📍 Format pane > X-axis

To show or hide category names on the horizontal axis

Default: On

Data labels

📍 Format pane > Data labels

To display numeric values on each bar for easier reading

Default: Off

Y-axis

📍 Format pane > Y-axis

To show or hide the vertical axis with numeric scale

Default: On

Common Mistakes

Not assigning the numeric field to the Y axis

Without the numeric values, the chart cannot show increases or decreases

Always drag a numeric field like sales or amount to the Y axis well

Using too many categories causing clutter

Too many bars make the chart hard to read and understand

Limit categories to key items or group smaller ones together

Using similar colors for increases and decreases

It confuses viewers about which bars represent gains or losses

Use contrasting colors like green for increases and red for decreases

Summary

Waterfall charts show how a starting value changes through increases and decreases to a final value.

They help explain step-by-step changes in financial or business data clearly.

Remember to assign numeric values and use clear colors for best understanding.