Combo Chart - choosing secondary axis

[AxelEnglund]

Hi, I am trying to create a combo chart and choose which one to be secondary axis - like you do in excel, see picture. This seems to be impossible in PBI. I have columns and it is now two on the left y axis and 2 on the right secondary 2 axis. I want to have them all three on left y axis and only one on the right axis. Is this possible??

[AxelEnglund]

Thank you!! Worked very well 🙂

[Anonymous · Accepted solution]

Thanks for the reply from amitchandak, please allow me to provide another insight.

Hi @AxelEnglund ,

You can try this custom visual: Multiple Axes Chart - XViz.

It supports adding up to 5 Y-axes.

You can assign columns to either the primary Y-axis (Value Axis 1) or secondary Y-axis (Value Axis 2) on demand.

As shown below, I have assigned columns A,B,C to the primary Y-axis (Value Axis 1) and column D to the secondary Y-axis (Value Axis 1) .

You can also set the display type for any series.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@AxelEnglund , In power bI Seconday Y-axis (Line) can not use legend. You can only use mutiple measures.
In case you need both Lines on you have option in line visual, but you will not able use legend in case you use line on seconday y axis.