Stacked Waterfall Chart with native visuals

[Sourav_M]

Dear All,

I have a requirement to show data in the below format but without using any custom visual. How can I create this visualization in Power BI, any help would be appreciated.

Thanks !!

[v-sdhruv]

Hi @Sourav_M ,
I hope you were able to resolve the issue. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[DataNinja777 · Accepted solution]

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,

[Sourav_M]

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 !!