want to create a waterfall chart

[ayush_sinha]

Can someone help me to create a waterfall chart. I have attached the data https://docs.google.com/spreadsheets/d/1izuzjYcbHkTAYiqiK8fxeHiHhKsws9sL/edit?usp=drive_link&ouid=10... 
waterfall chart 

[ayush_sinha]

https://docs.google.com/spreadsheets/d/1izuzjYcbHkTAYiqiK8fxeHiHhKsws9sL/edit?usp=sharing&ouid=10794...
use this link

[Ritaf1983 · Accepted solution]

Hi @ayush_sinha 
You need to unpivot your table before starting work with visualizations (with PQ):

and then you can put the data on the needed graph :

PBIX is attached.
Link to more information about unpivot :

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

detailed guides to waterfall charts in my first response 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Uzi2019]

Hi @ayush_sinha 
You can paste your sample data from excel to here. would be better to see the data beacuse the link you have shared is not working.

[Ritaf1983]

Hi  @ayush_sinha
The link is broken anyway, you can use the linked guides:

https://www.youtube.com/watch?v=hURn6BfONBU

https://www.youtube.com/watch?v=FL09rVAzrX4

https://www.youtube.com/watch?v=BfACOEiPK8M

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly