Forum Discussion
Stacked Waterfall Chart with native visuals
- 1 year ago
Hi Sourav_M ,
To replicate the stacked waterfall chart shown in your image using only native Power BI visuals, you'll need to use a stacked column chart and carefully structure your data to simulate the effect of a waterfall. Power BI doesn't support stacked segments in its native waterfall chart, so the trick is to break down each phase (Start, Deltas, End) into individual components and use stacked columns where appropriate, while single-value columns represent deltas.
First, structure your data like this:
Step Category Value Order Color Start Black Base 444 1 Black Start Yellow Layer 111 1 Yellow Start Green Top 222 1 Green Delta 1 Delta Black 40 2 Black Delta 2 Delta Yellow -10 3 Yellow Delta 3 Delta Green -20 4 Green End Black Base 484 5 Black End Yellow Layer 101 5 Yellow End Green Top 202 5 Green In Power BI, this visualization can be approximated using a stacked column chart. Assign the Order column to the Axis, Category to the Legend, and Value to the Values field. This approach allows the Start and End steps to be displayed as stacked columns, while the intermediate steps (representing changes) are shown as single-segment columns.
To ensure the chart is visually consistent with the intended design, sort the Axis by the Order column, and configure the color assignments in the "Data colors" section to align with the desired palette (e.g., black, gold, and green). Data labels should be enabled or disabled selectively to improve readability. It may also be necessary to remove gridlines, hide axis titles, and adjust bar spacing to clearly distinguish the intermediate change bars from the stacked totals at the beginning and end.
Although this method does not replicate all interactive features of a native waterfall chart—such as automated subtotals or dynamic breakdowns—it provides a viable solution using standard Power BI visuals.
Best regards,
Hi DataNinja777,
Thanks for the quick response. I understand the solution that you have suggested and I believe, on top of this, we would need to use the running total of the Start step so that our delta column will start from the top of start bar. I will try to implement this way. Thanks a lot for the guidance !!
Hello, were you able to create this chart? I followed the same steps, but the three middle columns are not appearing at the top of the chart.