Forum Discussion
waterfall chart
hello
really need some help
I need to create a waterfall chart to see gm variance from period a to b breakdown by category
I already did all the calculations for the measures so I just need to arrange the data in one table in order to build the visualisation.
I really appreciate if someone can share an example of how to with the command and build the tables for the waterfall char
thanks
Ron
3 Replies
- parry2kSuper User
ron_l100 it will be easier if you share some sample and what you are looking for. hard to answer without knowing the data. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 - ron_l100Regular Visitor
example :
this is the table that represents the start and the end of the waterfall and the category that I want to present
I another table I already calculate all the measures like LY GM, CY GM, production, etc.
now I need to build the waterfall chart.
How I am writhing the commend that each component 1-8 above will present the correct measure in the waterfall chart?
- AnonymousNot applicable
Hi ron_l100
Maybe you can refer to the content in the link below, which explains in detail how to create a waterfall chart correctly. You should be able to get some inspiration.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-waterfall-charts
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.