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,
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.