How to build a Waterfall Chart with multiple columns

Hello @DivyaAluri3

I have a test building a sample.

You must create two additional tables.

Category table:

Breakdown table:

My data table:

Build a measure:

Measure = 
VAR _StartingHC =  SUM('Table'[Starting HC])
VAR _External = SUM('Table'[External Hire])
VAR _Rehire = SUM('Table'[Rehire])
VAR _Transfersin = SUM('Table'[Transfers in])
VAR _TransferOut = SUM('Table'[Transfers Out])
VAR _Vol = SUM('Table'[Vol])
VAR _INV = SUM('Table'[Inv])
VAR _EndingHC = SUM('Table'[Ending HC])
Return
  SWITCH (
    SELECTEDVALUE (Category[CategorySort] ),
    1, SWITCH (
        SELECTEDVALUE (Breakdown[Breakdown] ),
        "External Hire", -1*(_External-_StartingHC),
        "Rehire",-1*(_Rehire-_External),
        "Transfers Out",-1*(_TransferOut-_Transfersin),
        "Vol",-1*(_Vol-_TransferOut),
        "Inv",-1*(_INV-_Vol),
        _StartingHC
    ),
    2, SWITCH (
        SELECTEDVALUE (Breakdown[Breakdown] ),
        "External Hire", 0,
        "Rehire",0,
        "Transfers Out",0,
        "Vol",0,
        "Inv",0,
        _EndingHC
    )
)

Result:

It seems that the waterfall chart will not be sorted by breakdown now: Classification in the attribution distribution of the waterfall chart does not work

And you can check out this blog for more details on how to create this waterfall chart: How to make waterfall charts work

You can download my pbix file from this link: How to create a multi-column waterfall chart

Best regards

Rico Zhou

If this post helps,then consider Accepting it as the solution to help other members find it faster.