Forum Discussion

AxelEnglund's avatar
AxelEnglund
New Member
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
1 year ago

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.