waterfall chart

[ron_l100]

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

[Anonymous]

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.

[ron_l100]

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? 

[parry2k]

@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