I have a measure in my data model which shows the Average Score that respondents gave to questions in a survey. The response values can range from 1 (not satisfied) to 7 (very satisfied). I am displaying this measure on a stacked column chart, with another dimension (department name) on the X axis.
By default, Power BI will show the Y Axis as starting at 0. If I set the Y Axis Start value to 1, then in some cases, the Y axis will update, and show that the minimum value is 1, though the actual value of 1 is not always shown.
If I set the End value to 7, then the Y Axis will update again, but this time it shows a starting value of 0, even though the value in the Start box clearly shows 1. The behaviour is just really inconsistent. The screenshot below shows 6 column charts showing the average response for each department, across 6 thematic areas. All 6 charts have the Y-axis start value set to 1 with the end value set to Auto. In only 2 instances do the charts actually start from 1, and even in those examples, the 1 isn't shown on the axis!
For the two charts that do start from 1, if I alter the Y-axis end value to 7, the axis immediately reverts to showing 0 and 5 as in the other 4 charts.
Could we have more control over the axis start/end values, and the intervals as well please?
Note: The same behaviour was observed in the stacked bar chart, clustered bar chart and clustered column chart visuals.