Data Visualization with Microsoft Power BI

Chapter 14. Waterfall Chart

For the practice, please download a special dataset.

In this chapter, we will begin with the default visual provided by Microsoft and discuss its features and limitations. We will pay attention to data preparation and introduce you to Power Query. Finally, we’ll end with a simple waterfall and explain its benefits.

To make informed decisions based on data, it is not sufficient to merely compare target versus actual values. In certain processes, such as manufacturing, finance, or enterprise sales, it is crucial to understand the specific factors that contributed to the deviation from the plan. If you possess detailed data on the influencing factors, the most effective way to visualize them is through a waterfall chart. Although it is included in the basic set of Power BI visuals, we consider it an advanced option due to the intricacies involved in its construction. Further, we will explore alternative variations of waterfall charts available in the AppSource gallery.

Let’s begin with a straightforward example of Apple sales. Suppose that sales in 2022 and 2023 turned out to be roughly the same, with a growth rate of less than 1%. However, as you’ll see in the waterfall chart in Figure 14-1, iPhone and iPad sales have declined, while accessory sales have shown the highest growth.

Figure 14-1. Apple sales by product 2022–23, $ billions

The data provided ...