Waterfall Chart: Need Help with Start, Movement, End

Hi TH_BI ,

A similar effect can be achieved, but since the waterfall bars field is a text field, the x-axis sorting may not be accurate.

M_sum =
IF (
    MAX ( Table_test[Waterfall Bars] ) = "Starting Bar",
    1000,
    CALCULATE (
        SUM ( Table_test[Monthly Movement] ),
        ALLEXCEPT ( Table_test, Table_test[Waterfall Bars] )
    )
)

related document:

Waterfall charts in Power BI - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.