Colin Power BI User 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 (52)
RE: dynamic axis scaling
You can duplicate the visual, adjust the scaling, then create a bookmark with the duplicate visible and the original hidden. You can then use +/- icons to switch between the two. It can be made to look fairly seamless, however it's still ridiculous that dynamic axis scaling still hasn't been implemented and report users and designers have to use such a workaround.
RE: dynamic axis scaling
This has been requested by my client and it would be a great enhancement. Does anyone have a workaround?
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.