Bug? Small multiples breaks shared y axis on line and clustered column chart

[TM_Visual]

[edit] I have reported this as an issue here.

I have a chart with several categories on the x axis. I want to display two sets of values: Columns showing 'sample' and 'target' on the alternate value, the line chart. I would like them to exist on the same, shared axis.

Normally there is no issue with the line and column accurately showing on the same axis.

However if 'small multiples' are used, the y axis scaling is based on the column only, and values on the alternate y axis will move down to be visible, even if they are much higher.

I have prepared an example visual (fake data). As you can see, the y axis cuts out at the 800 mark, when it should go up to above 2000. The problem occurs regardless of whether the small multiple panes are vertically or horizontally aligned.

 Is there a workaround, is this a known bug, and is there a fix planned?

I can provide my test pbix file if helpful to developers.

[Anonymous]

I have the same issue, the most recent update to Power BI destroyed the Small Multiples... It's a real shame, hope it gets fixed soon.

[rubayatyasmin]

Hi, @TM_Visual 

try this:

1. Synchronize Axis for Small Multiples: To make sure all your charts in small multiples have the same scale, you need to synchronize the axis. Go to the Format pane, expand the Y-Axis option, and then turn the "Sync Axis" setting to On.

2. Secondary Axis: In Power BI, you have the ability to utilize a secondary Y-axis for your line chart. To do this, click on the line chart visual, go to the 'Format' pane, and under 'Y-Axis', change 'Y-Axis Position' to 'Secondary'. This could solve the issue of the line chart not being displayed properly.

[TM_Visual]

Hi @rubayatyasmin ,I am afraid that your suggestions did not apply.

1. In the Y-axis section of the formatter I have selected 'shared y axis' as 'on'. This does ensure that the y axis is shared for the primary, column values, but that alignment breaks the secondary, 'line' values.

2. Turning on the secondary y-axis, the values will not align with those on the primary y-axis, which is what is often required.

-----------------------

Another screenshot to illustrate my point:

The Target value for Man-USA is very high, but in the second picture (blue columns) , the number is displayed correctly on the tooltip but the marker is too low.

I'm guessing that this is the result of the small multiples feature for these charts not having the axis designed to use the highest of all values. The range of the shared y-axis is determined entirely by the primary measure used, and not by the full range of both of the primary and secondary.

I'm have reported this as an issue here