Waterfall chart with multiple measures

Hi Krishna1826 ,

Thank you for reaching out to the Microsoft Community Forum.

You have 13 measures, and you want a single waterfall chart where some measures start fresh from zero and others continue cumulatively. This is not directly supported by Power BI native waterfall, but it work using a disconnected table.

Please follow below steps.

1. Created disconnected table with sample data.

2. Created Below Measure .

Waterfall Value =

VAR CurrentOrder = SELECTEDVALUE(MeasureOrder[Order])

VAR CurrentGroup = SELECTEDVALUE(MeasureOrder[Group])

VAR RunningTotal =

    CALCULATE(

        SUMX(

            FILTER(

                MeasureOrder,

                MeasureOrder[Order] <= CurrentOrder &&

                MeasureOrder[Group] = CurrentGroup

            ),

            MeasureOrder[Value]

        )

    )

RETURN

RunningTotal

 

3. Please refer below Output snaps and attached PBIX file

 

 

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh