on 12 Feb 2016 23:18:15
Option to allow dynamic axes on charts - allow an option in chart setup to allow the axies to change dynamically based on the values within - the start and end of an axis are fixed, despite values changing when filters are applied
- Comments (50)
RE: dynamic axis scaling
I have a basic monthly headcount for our company - numbers across months in the 2500 range, we also have 9 regions that I have slicer for.
I want the Company level to show the variance more clearly so set the y axis scale to a smaller range, but this doesn't work when the region slicer is used due to the headcount being below the company level pre set scale.
I'd be really useful if I could set the y axis scale range by a % of the existing data i.e. x% above highest value in the data set to x% below so it changes consistently across non filtered and filtered data sets versus current functionality of fixed numbers.
RE: dynamic axis scaling
Any update on this feature?
RE: dynamic axis scaling
Perhaps just as important is the ability to dynamically switch from 0 end to -1 (lowest value) end. Sometimes you want to see the whole magnitude, sometimes you want to focus on the changes. Would love to be able to do with with a formula.
RE: dynamic axis scaling
Any update?
RE: dynamic axis scaling
Any progress on this? Having to manually adjust charts is painful and looks unprofessional
RE: dynamic axis scaling
It can be very misleading having a bar and line graph with two different scales.
Even though we can align zero’s on the Y scale, if one scale is different than the other, wrong conclusions are derived from the analysis. One might think that positive values compensate the negative ones when in reality they’re just a fraction of the value.
RE: dynamic axis scaling
Has this been resolved? I don't see an updated feature yet which incorporates the idea here. This is a very important feature found in Excel!!!
RE: dynamic axis scaling
Is there any plan to add this? Really important for the work I do.
RE: dynamic axis scaling
Come on @Microsoft PBI Team !!
RE: dynamic axis scaling
For line graphs it would be great to be able to change the axis using a slicer. Particularly when using the Play Axis as the Y-axis in a line chart does dynamically change, which is great when you look at it as an animation.