How to create up down chart

[naoki]

Hi 

How do I create an up down chart like below? Which is done on excel, I am unable to replicate this chart format in PowerBI. 

[Ritaf1983 · Accepted solution]

Hi @naoki 

The chart in the picture doesn't make sense mathematically. 
Columns down should only have negative numbers.
If you want to see the direction of changes, you can use a line graph with the option
"Stepped" if you need it.
Or the waterfall graph.
Examples :
Stepprd line:

Waterfall :

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