topic Re: How to align waterfall chart list in DAX Commands and Tips

How to align waterfall chart list

Anonymous — Thu, 11 Nov 2021 09:09:52 GMT

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

Re: How to align waterfall chart list

Anonymous — Fri, 12 Nov 2021 05:02:29 GMT

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.

Re: How to align waterfall chart list

v-cazheng-msft — Mon, 15 Nov 2021 02:06:33 GMT

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!