Forum Discussion

naoki's avatar
naoki
Helper I
3 years ago
Solved

How to create up down chart

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. 

 

 

  • 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

1 Reply

  • 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