Forum Discussion

Vivek26's avatar
Vivek26
Advocate I
4 years ago
Solved

Replicate Excel custom combo chart Into Powerbi

Excel has an option for Custom combination of Combo chart which allows us to place line and column chart on the same axis.

I have a situation where I want to place FewLine charts and  a column chart on same axis and the remaining line charts on the secondary Y axis. The Powerbi Combo charts work fine if I had to place all lines on secondary axis and columns on Primary Y axis 

but I am not able to replicate this behaviour in Powerbi I did try the multi axis custom visual but it is not giving the perfect scaling.

Can you please help me out here ?  

 

 

 

  • Vivek26 , IN power BI, You can have line and bar on the same axis - Switch off the secondary axis.

    You can have bar on primary and a line on secondary , switch on the secondary axis

     

    The line will not split by legend and the bar can not be placed on the second axis.

1 Reply

  • Vivek26 , IN power BI, You can have line and bar on the same axis - Switch off the secondary axis.

    You can have bar on primary and a line on secondary , switch on the secondary axis

     

    The line will not split by legend and the bar can not be placed on the second axis.