Skip to main content

Power BI

New

Allow use of variable for Y-Axis scale

Vote (74) 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 (3)
Jeff Brown's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 10 Jul 2020 17:22:39

RE: Allow use of variable for Y-Axis scale

So often we are forced to set a fixed y-axis to display data in a way that is intuitive to the user, but that is just a regression waiting to happen when the data changes. Please allow us to set a min and max based on measures so that we can empower the user to intuitively compare values on different charts!!

Jeff Brown's profile image Profile Picture

9cc04936 265e-4c63-a9f5-f43ad9614f52 on 05 Jul 2020 23:57:36

RE: Allow use of variable for Y-Axis scale

Ok

Jeff Brown's profile image Profile Picture

09789230 fd3d-4188-8cbc-4ebc8f6f2780 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.