Skip to main content

Power BI

Needs Votes

Allow use of variable for Y-Axis scale

Vote (154) Share
Jeff Brown's profile image

Jeff Brown on 21 Aug 2017 16:18:34

It should be possible to use a measure to determine the scale of the Y axis in charts. Currently the options are to automatically scale according to the content, or to have a fixed scale.
When there are two graphs side-by-side, it's often important that they share the same Y axis. Hard-coding it, though, can result in a poor experience for graphs with high volatility (i.e. any graph when slicers/interactions are involved).

If you could use a measure to determine Y axis height, you could have a "max of both graphs" measure to allow them to share the same axis.

Comments (12)
Jeff Brown's profile image Profile Picture

Rodrigo on 05 Jul 2020 23:57:36

RE: Allow use of variable for Y-Axis scale

Ok

Jeff Brown's profile image Profile Picture

Power BI User on 05 Jul 2020 23:28:37

RE: Allow use of variable for Y-Axis scale

This would be a great addition.

If I have a column with values between 1-100 that is used as x-axis on a scatter plot i should be able to set axis end to a measure that is for example [MAX(value) * 1.1] so that the axis end becomes 110. If I then do some filtering so the max value in the chart is 80 the axis end would become 88.