How to align waterfall chart list

Hi Anonymous 

You may try this solution. Firstly, you need create a Calculated column as follows.

Order =

VAR bucket = 'Master Data Base'[Reduction buckets]

VAR month_ = 'Master Data Base'[Month]

RETURN

    SWITCH (

        TRUE (),

        bucket = " Glidepath RF06"

            && month_ = "Dec 2020", 1,

        bucket = "Ex rate", 2,

        bucket = " Overstock Consumption", 3,

        bucket = "New Materials", 4,

        bucket = " Scrap", 5,

        bucket = " Supply Improvements", 6,

        bucket = " Sell Back to OEM´s", 7,

        bucket = " Glidepath RF06"

            && month_ = "AC Sep", 8

    )

Then, you need sort Waterfall_ column with this newly created Calculated column.

After that, make sure that your visual is sorted by Waterfall_ column in ascending.

Attached pbix file as reference.

Best Regards,

Community Support Team _ Caiyun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it, please feel free to let us know. Thanks a lot!