Forum Discussion

Sourav_M's avatar
Sourav_M
Frequent Visitor
1 year ago
Solved

Stacked Waterfall Chart with native visuals

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.   Than...
  • DataNinja777's avatar
    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,