Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Waterfall Chart Axis

Hi,

 

I´m having trouble with showing the x axis. I have a waterfall chart that fluctuates arrond zero. I want to be to see the x axis in order to know if i´m bellow zero or not.

 

What I have:

 

What I want:

 

It´s possible?

 

Thanks!

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    So, I changed the waterfall chart to a stack column chart, and "created" a waterfall chart, just like in Excel. The stack column chart has Analytics, so I added a constant line in zero. It´s not the best, but it´s a solution. Hope It helps.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous - You can insert a Shapes> line and rotate it to 90 degrees.

     

    Something like- 

     

    Hope this helps,

     

    Cheers,

    -Namish B

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      The chat changes in funtion of the client, so it has to be part of the chart. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      How do I do it? It´s driving me crazy! amitchandak 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

     

    I think you want to clearly see the main reasons for monthly changes.

     

    Please kindly refer to this blog, which explains the role of Breakdown bucket:

     

    https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-waterfall-charts#explore-the-waterfall-chart

     

    Based on my test, I falied to add the x axis. The only I can do is to set Gridlines.

     

     

     

    Best Regards,

    Stephen Tao

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago
    If it's not passible in the standard visual, please try to find a custom visual with the functionality you're after.
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    So, I changed the waterfall chart to a stack column chart, and "created" a waterfall chart, just like in Excel. The stack column chart has Analytics, so I added a constant line in zero. It´s not the best, but it´s a solution. Hope It helps.