A waterfall chart shows a running total as values are added or subtracted. It's useful for understanding how an initial value (for example, net income) is affected by a series of positive and negative changes.
The columns are color coded so you can quickly tell increases and decreases. The initial and the final value columns often start on the horizontal axis, while the intermediate values are floating columns. Because of this "look", waterfall charts are also called bridge charts.
Waterfall charts are a great choice:
when you have changes for the measure across time series or different categories
to audit the major changes contributing to the total value
to plot your company's annual profit by showing various sources of revenue and arrive at the total profit (or loss).
to illustrate the beginning and the ending headcount for your company in a year
to visualize how much money you make and spend each month, and the running balance for your account.
To follow along, sign in to Power BI and select Get Data > Samples > Retail Analysis Sample.
From the "Retail Analysis Sample" dashboard, select the Total Stores tile to open the "Retail Analysis Sample" report.
Select Edit Report to open the report in Editing View.
Create a waterfall chart that displays this year's sales and sales goal by month.
Convert the chart to a Waterfall.
If Total Sales Variance isn't in the Y Axis area, drag it there.
Select Time > FiscalMonth to add it to the Category well.
For information about using the Filters pane, see Add a filter to a report.
Highlighting a column in a waterfall chart cross-filters the other visualizations on the report page... and vice versa. However, the Total column does not trigger highlighting or respond to cross-filtering.
More questions? Try the Power BI Community