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)
RE: Allow use of variable for Y-Axis scale
Absolute need. Please vote for this.
RE: Allow use of variable for Y-Axis scale
This feature should be an absolute requirement. Why would you even want a combo chart if you can't make all the elements use the same scale? The combo chart feature in Power BI is pretty much worthless without this.
RE: Allow use of variable for Y-Axis scale
Agree we should be able to have a variable that controls chart scales. In addition and even more important than that in my opinion is to have end user chart scale control. That is a very basic reqt, disappointed it is not available. Would be good to have user controls for pan and zoom of charts as part of this ... look at how plotly does it
RE: Allow use of variable for Y-Axis scale
Custom x/y scales missing? No way to turn off automatic scaling when slicing? No way to set static x/y labels?
This is a very basic functionality that absolutely should be part of the software. To be honest, I'm a bit shocked how bad the Power BI visual customization settings are. I thought Excel was bad, but for graphs/visuals PowerBI seems to have even less functionalities that that. I need Python/R scripts for even basic visuals, but this is likely to cause problems to interactive viewing.
RE: Allow use of variable for Y-Axis scale
Sometime the auto scaler just doesn't get it right so being able to override it with a dynamic changing (max of 10% above data for example ) would be extremely useful.
RE: Allow use of variable for Y-Axis scale
This would be a nice feature.
We often work with the "Line and Stacked Column Chart" visual in which the line has the same measurements as the stacked columns. I.e. comparison of worked hours (stacked columns) with contracted hours (line). It would be nice when both Y-axis could have the same scale especially when using segmentation.
RE: Allow use of variable for Y-Axis scale
If you are doing this, please make sure it works for all charts involving y-axis, that is: line charts, column charts, area charts and any variant on these. And, preferably, also the scatter chart.
RE: Allow use of variable for Y-Axis scale
This would really be extremely helpful. One of my reports involves an area chart overlayed with a line graph. Obviously, the y-axis needs to be the same, otherwise the resulting image does not make sense. However, the y-axis also need to be dynamic!
I am currently having to make very complex workarounds with tens of lines of M and DAX code to work around this missing feature.
RE: Allow use of variable for Y-Axis scale
Should be obvious something like this is necessary to set a dynamic goal line on combo charts...
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!!