Forum Discussion
How to align waterfall chart list
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
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!
2 Replies
v-cazheng-msftCommunity Support
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!