Forum Discussion

nazishm's avatar
nazishm
Regular Visitor
3 years ago
Solved

Fix y axis scale in Clustered column chart

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 valu...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

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