Forum Discussion
Solved
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...
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 🙂