Waterfall visual: add additional disconnected bart

Hii PowerToBI 

standard waterfall chart doesn't support "selective" breakdowns, you must trick the chart by putting both your main categories and your subcategories into the Category bucket of the visual, leaving the Breakdown bucket empty.

​1. Create a "Waterfall Axis" Table

​Create a new calculated table that contains every label you want to see on the X-axis in the exact order you want them.

WaterfallAxis = 
UNION(
    DATATABLE("Label", STRING, "Order", INTEGER, "Type", STRING,
        {
            {"Intro", 1, "Pillar"},
            {"A", 2, "Breakdown"},
            {"B", 3, "Breakdown"},
            {"C", 4, "Breakdown"},
            {"Start", 5, "Pillar"}, -- Or "End", depending on your logic
            {"End", 6, "Pillar"}
        }
    )
)

Note: Ensure you set the Sort by Column for "Label" to the "Order" column.

​2. Create the Dynamic Measure

​You need a measure that calculates the correct value based on which label is being filtered on the axis.

Dynamic Waterfall Value = 
VAR CurrentLabel = SELECTEDVALUE('WaterfallAxis'[Label])
RETURN
SWITCH( CurrentLabel,
    "Intro", [YourIntroMeasure],
    "A", CALCULATE([Amount], 'BreakdownTable'[Breakdown] = "A"),
    "B", CALCULATE([Amount], 'BreakdownTable'[Breakdown] = "B"),
    "C", CALCULATE([Amount], 'BreakdownTable'[Breakdown] = "C"),
    "Start", [YourStartTotalMeasure],
    "End", [YourEndTotalMeasure]
)

3. Configure the Visual

• ​Category: Use 'WaterfallAxis'[Label].
• ​Breakdown: Leave this Empty.
• ​Values: Use your [Dynamic Waterfall Value] measure.

Important Note on Totals

​In a standard waterfall, the "Total" column is usually automatically generated. If you want "Start" or "End" to act as a "running total" or "summary" pillar, you may need to go to the Format Pane > Pillars and manually define "End" as a total, or ensure your DAX measure for that specific label returns the cumulative sum rather than a delta.

If this dynamic calculation solves your category-based KPI tracking, please mark this as the "Accepted Solution"!