Forum Discussion
Column chart values do not stay vertical?
Hi,
I have a Line and stacked column chart, when my sliders ar set somtimes I get vertically 0 to 5 as I expect (see below)
...if I change my sliders that set other info in the chart see how 0 is at the same height as 2, 1=3 and 2=4. All I want is to keep the vertical values on the left and above each other so this chart makes sense.
Thanks,
Dan
A Microsoft Developer supplied the answer. There is a somewhat bug in the Show secondary setting.
This setting actually has 3 states and not 2. By default it appears as OFF but it’s really set to Auto (but looks off). Once you set it on then off again, it stays off. If in the undefined state, if the variation between numbers on the axis exceeds 10% the auto feature changes the state. Setting it explicitly removes the Auto.
Hopefully this will be resolved in the near future.
7 Replies
Hi,
It seems the issue happens when the Line Value (Red horz red line) has a higher value than the Column values. Is there a solution or work-around for this?
Thanks,
Dan
Hi dtartaglia. I found a setting that will prevent the secondary Y axis from showing, and fixes the issue. If you click your chart, then click the paintbrush in the visualizations pane, expand the Y-Axis section. Scroll down to the bottom of the Y-Axis section and there's an option for Show secondary. Turn it off and you should be good to go.
Hi KGrice,
Thanks for the suggestion but that setting was off :-(
From my testing it seems that if the line value has a value higher than the columns this issue happens othrwise the chart appears correct. I'm not sure what's going on. I thought about using DAX to check for this condition then not show the line if it happens but that's a bad work-around.
Thanks,
Dan
