This seems odd, and I have not been able to recreate it using sample data. Would you be able to post the packaged workbook (twbx file)?
I was able to figure this out.
I was using a dual axis and so fixing the axis was giving an odd output.
On removing the other axis and fixing the percentage axis to 40%, I was able to get the required visual output.
Thanks again for your time.
I have a generic question on this issue. I have different charts with percentage values that could potentially range from 0% to 100%. So my scale needs to be able to cover the entire 0-100%; I can't fix the scale.
However, many times, the values are 90% or above. When I make the scale "automatic", the axis ranges from 0 to 100% and all the values bunch up at the top.
Is there a way to make the axis "dynamically" zero in on the range where the values are? For example, if they are all in 90% above range, can I indicate to Tableau to make the scale 90 - 100%; but if there is some value say at 40%, then I want Tableau to scale from around 35 to 100%.
So I don't want the scale to be either generally "fixed" or "automatic" - but more a decision based on the data points.
Even i am facing the issue of dynamically changing the axis of bar chart as per the data. Like if most of the values are in the range of 80-100, the axis should also change accordingly instead of starting from 0 to 100. Can anyone suggest some solution for this.
There is a check box to 'Include Zero' when choosing Automatic Axis. If you uncheck it as per examples on attached workbook then this should scale your axis. To Edit Axis right click the axis and choose Edit Axis...
Hope this helps.
Thanks much Ian! It is helpful