power bi line graph with x and y axes crossing at zero

76 Views Asked by At

I've got this dataset:

enter image description here

Which produces a line graph like this:

enter image description here

I want the x and y axes to cross in the middle like this (excuse the shaky lines):

enter image description here

I can't see an option to do this with the power bi standard line chart (power bi version 2.123.684.0). Is there either another standard visualisation I can use to get this result, or does anyone know of a paid component that does it?

2

There are 2 best solutions below

0
davidebacci On BEST ANSWER

In the format pane, click Analytics and add two constant lines at 0.

enter image description here

0
AHSAN UL HAQ On

After clicking on "Power BI Visual" within the new format pane, you will find the option for a Constant Line with multiple choices:

X-Axis Constant Line Y-Axis Constant Line Average Constant Line Median Constant Line Percentile Constant Line You can insert an X-Axis line only when both metrics are present on the X and Y sides; otherwise, it will not be possible.