Waterfall chart breakdown

The waterfall chart is one of the most powerful standard visuals in Power BI given its ability to compute and format the variances of individual items between two periods by default. The items representing the largest variances are displayed as columns of varying length, sorted and formatted with either an increase (green) or decrease (red) color. This built-in logic and conditional formatting makes waterfall charts both easy to create and intuitive for users.

In the following example, the Internet Sales of the last two completed months is broken down by Sales Territory Country: 

Waterfall chart with breakdown

Note

The waterfall chart naturally walks the user from the starting point category on the left (2017-Oct) to the ending point category on the right (2017-Nov). As per the preceding image, hovering the cursor over a bar results in the details for this item being displayed as a tooltip. In this example, hovering over the ($15K) red bar for the United States displays...