Line and Stacked column chart with 2 lines: Secondary axis

[Ptolemaida]

I have a Line and Stacked column chart.

I have 2 measures in the column part.

And i have 2 measures in the lines part. 

Power BI automatically plots both lines on the primary axis, along with the column's values. => everything on primary axis

If i remove 1 line measure and i have only 1 line, the line is automatically plotted on the secondary axis.

However:

I want to plot 1 line on the primary axis, and 1 line on the secondary axis.

How can i achieve this?

[v-kpoloju-msft]

Hi @Ptolemaida, 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @MFelix, for his inputs on this thread.

Has your issue been resolved? If the response provided by the community member @MFelix, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @Ptolemaida,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[MFelix · Accepted solution]

Hi @Ptolemaida ,

One question before I answer are all the measures you are using in the same unit? Or are you using different units?

Try to go to the Y-Axis and then secondary axis and turn values on you should also probably align 0

This shluld get expected result.