Line and Stacked Column Chart SHOWS different behaviors on Secondary Y-axis

[JChai]

Hey there,

I am getting different behaviors on Secondary Y-axis while using the slicer to illustrate different item's quantity and costs overtime with Line and Stacked Column Chart. The chart with default properties ideally should show something like the below using Auto Minimum and Maximum range.

However, some items are displaying the Secondary y-axis with the same range value but the line is moving up and down as shown below. Note that all costs for Secondary y-axis are the same throughout all period, thus, the line should be flat.

Some items using the same chart are showing missing Secondary Y-axis when the Secondary Y-axis is explicitly turn on as shown below. Note that the cost shown below is NOT zero and all costs are the same for X-axis periods. 

I can resolve this issue by turning on Align zeros, however, I think this might be a bug within the Auto Range property where the Secondary y-axis is showing inconsistent behaviors for the same visual switching among different items from the slicer. It will be great if this can be brought up to the developers attention and have it resolved soon. Thank you.

Best,

JKChai

[JChai]

@lbendlin Thank you for your comment. I don't think I understand the dimensionality that you mentioned. I had tried changing the qty to decimal that represent per million qty but the issue still persists. For the second example, the cost is $0.352 for all periods but I don't understand why the fluctuation is needed for this chart; For the third example, the cost is $0.21 for all periods which all items from the slicer have the same number of periods but Secondary y-axis got squished out. All these seem to suggest that something working behind-the-scene to generate Secondary y-axis with the Auto MIN/MAX range is behaving unexpectedly. In my opinion, I think this need to be resolved otherwise I don't see the Auto MIN/MAX range function being useful here. Thank you. 😇    

[lbendlin]

I agree, the min value of the Y axis should be pegged at zero for charts showing positive values.

[lbendlin]

the dimensionality for quantity and cost is different, so when you  try to show both on the same axis the cost loses out as it is getting squished down.

Your second example is technically correct, revealing small fluctuations in your cost numbers. However the general recommendation is to always peg the minimum Y axis to zero so as to avoid misinterpretation of the data.