Forum Discussion

WishAskedSooner's avatar
WishAskedSooner
Icon for Continued Contributor rankContinued Contributor
1 year ago
Solved

Y-Axis Auto Range for Column Charts

For the Line Chart visual, the Y-Axis range updates automatically to reflect the Min/Max of the data. For example, if the Min value being plotted is 1.54, the Minimum of the Y-Axis is 1.5. All is well.

 

However, if I change my visual to a Stacked or Clustered Column Chart, the bottom value of the Y-Axis defaults to 0. This results in a loss of resolution between the various values being plotted because the range is now larger.

 

Is there a setting somewhere that can have the Y-Axis of Column Charts update automatically the same way Line Charts do?

 

Thanks!

  • You can have the min and max defined by the result of measures

2 Replies

  • Deku's avatar
    Deku
    Icon for Super User rankSuper User

    You can have the min and max defined by the result of measures

  • WishAskedSooner's avatar
    WishAskedSooner
    Icon for Continued Contributor rankContinued Contributor

    That actually worked to my surprise. The tootip "Conditional formatting" threw me off because I thought it would just change the formatting. Yet, another thing in the PBI UX that is hopelessly confusing unless you have loads of experience.

     

    Thanks!