clustered line and column chart with dual y axis

[Prue]

I need to create a combo chart with one set of columns and up to 4 lines. This I can do easily enough but the lines are connected to the wrong y axis. For instance I need an daily value (numerical) reading from the left hand y axis which is the same y axis as the bar chart and the other 3 lines reading from the right y axis which displays yearly data (numerical). At the minute all lines are reading from the secondary (right hand) axis. Is there a way to assign which axis each line is attached to in power bi as you can in excel as shown below? In the image below from excel I have the "daily UG total metre target rate" and the "daily total metres UG" reading from the values on the left column and the other 3 from the secondary axis. Any help would be appreciated!!

[TomMartens]

Hey @Prue ,

unfortunately, this is not possible using the default visuals.

You can create an idea on ideas.powerbi.com.

And maybe there is a custom visual available inside the store, please check out the visuals.

Regards,

Tom

[Prue]

Thank you for your reply Tom. I took your advice and found a visual called multiple axis chart which does exactly what I need it too. So thank you again for the advice.