Forum Discussion
Waterfall Chart Help... Please and Thank you!!
We have created a nice waterfall chart to track, 'Total Cost Savings', but, we want to add a 'goal' column to the chart. Right now, we are having an issue becuase it doesn't seem like BI has the functionality to add that feature. Can anyone help?
Hi Anonymous ,
So, you want to put multiple columns/measures into "Values" Field of Waterfall Chart, right?
I'm afraid Waterfall Chart may not support multiple columns/measures.
You can post your idea on Power BI Ideas.
It is a place for customers to provide feedback about Power BI.
What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.Workarounds:
If you want to put two columns in waterfall chart and your data is like so:
You can try to use "UnPivot" to transform your data.
Then, create waterfall chart like so:
For multiple measures, please refer to this post: Waterfall Chart using Measures.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- parry2k
Super User
Anonymous I hardly used waterfall visual, you can always check custom visual, there are some really good ones with interesting features.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
- Icey
Community Support
Hi Anonymous ,
So, you want to put multiple columns/measures into "Values" Field of Waterfall Chart, right?
I'm afraid Waterfall Chart may not support multiple columns/measures.
You can post your idea on Power BI Ideas.
It is a place for customers to provide feedback about Power BI.
What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.Workarounds:
If you want to put two columns in waterfall chart and your data is like so:
You can try to use "UnPivot" to transform your data.
Then, create waterfall chart like so:
For multiple measures, please refer to this post: Waterfall Chart using Measures.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_AdminAdministrator
Dear ones, it always puts the highest value on me at the beginning. I need to lock the start and end values. please need help. when the beginning is smaller than the end, the other item appears. If it were the other way around, it would not be that value.
