Fix y axis scale in Clustered column chart

[nazishm]

I want to plot the average of all values on the Y-axis in the Clustered column chart. The average value is in Negative. 
But I want my chart to show even the positive axis, even though positive values aren't present.

This is how my chart is now. I need even positive axis to it.
Can anyone help me out with this.

[v-yueyunzh-msft · Accepted solution]

Hi , @nazishm 

According to your requirement description, you want to realize that even if there are no positive values in the column chart, you want to display the range of positive values corresponding to negative values in the y axis, right?

If that's the case, you can try my method:

You can create a new measure to find the maximum value of the absolute value corresponding to the value field in your column chart:

Measure = ABS(MAXX(ALL('Table'),'Table'[Value]))

You can then place this newly created measure in the FX of the Y-axis Maximum of the Column Chart:

Then we can meet your need:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[sudhav]

You can cfreate a Calculate column, from negative to positive and keep positive as positive.

= each if [COLUMN] < 0 then [COLUMN] *-1 else [COLUMN] *1)

you can also use ABS dax function for measures to convert them into positive number for showcase purpose