Waterfall Chart Axis

[Anonymous]

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!

[Anonymous · Accepted solution]

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.

[Anonymous]

If it's not passible in the standard visual, please try to find a custom visual with the functionality you're after.

[v-stephen-msft]

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.

[amitchandak]

@Anonymous , you can change the color to black. I did saw any option for axis line type.  You can log an idea -https://ideas.powerbi.com/ideas/

[Anonymous]

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

[NamishB]

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

Something like- 

Hope this helps,

Cheers,

-Namish B

[Anonymous]

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