Forum Discussion
Combo Chart - choosing secondary axis
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??
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.
3 Replies
- amitchandak
Super User
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. 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.Thank you!! Worked very well 🙂
