How to align waterfall chart list

[Anonymous]

 i have created  dax query for water fall chart  like  below 

Waterfall_ = var _res = IF('Master Data Base'[Reduction buckets]="Ex rate","Ex rate",

        if('Master Data Base'[Reduction buckets]=" Overstock Consumption","Overstock Consumption",

        if('Master Data Base'[Reduction buckets]=" Scrap","Scrap",

        if('Master Data Base'[Reduction buckets]=" Supply Improvements","Supply Improvements",

        if('Master Data Base'[Reduction buckets]=" Sell Back to OEM´s","Sell Back to OEM´s",

        if('Master Data Base'[Reduction buckets]="New Materials","New Materials",

        IF('Master Data Base'[Reduction buckets]=" Glidepath RF06"&& 'Master Data Base'[Month]="AC Sep","End Inventor",

        IF('Master Data Base'[Reduction buckets]=" Glidepath RF06"&&'Master Data Base'[Month]="Dec 2020","Starting Inventor")))))))) return _res

but i want order looks like below 

 how i will rearrange   the order . any idea . please help me 

[v-cazheng-msft · Accepted solution]

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!

[Anonymous]

Hello @Anonymous 
You can create a calculated table using the same logic and create an index column then sort the values based on the index column. Please create an appropriate realtionship. I hope this works for you.