Force one of the lines to use Y axis that Column uses in Combo Chart

[ritarita]

I have three measures (A, B and C) that need to be shown on a combo chart. Measure A needs to be a column and Measure B and C needs to be Lines. 

I want A and B to use the primary Y axis and C to use the secondary Y axis. Currently the chart is making B and C using the secondary Y axis and I can't find a way to make B using primary Y axis that the column is using.

I have seen posts about toggle on "secondary Y axis" but I don't have this option in my Power BI desktop. My version is 2.143.1204.0 64-bit (May 2025).

Is there a way to force it? 

[v-tejrama]

Hi @ritarita ,

I would also take a moment to thank @danextian and  @pankajnamekar25 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please Accept it as a solution so that other community members can find it easily.

[v-tejrama]

Hi @ritarita,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

If the response answered your query, kindly “Accept as Solution” and Give “Kudos” to help others in the community benefit from it as well.

Thank you.

Tejaswi.

[danextian]

Hi @ritarita 

The combo chart currenlty doesn't have an option to specify a secondy y-axis - just column and line y axes. 

If you want to be able to use a secondary y-axis, use the line chart.

[pankajnamekar25]

Hello @ritarita 

In Power BI, when you're using a combo chart with multiple measures, it can sometimes automatically assign your line measures to the secondary Y-axis based on the data scale. If you want Measure A as a column and Measure B as a line (both using the primary Y-axis), and Measure C as a line on the secondary Y-axis, you'll need to adjust this manually.

To fix it, go to the Format pane of the visual and look under the "Series" section. There, you can expand each measure and find the “Show secondary” toggle. Turn it off for Measure B to keep it on the primary axis and turn it on for Measure C to place it on the secondary axis.

If you don’t see the option, make sure you're using the default Combo Chart visual and that each series is properly added. Sometimes simply removing and re-adding the measures helps, or creating a duplicate measure can force Power BI to reset axis behavior.

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[ritarita]

Hi @pankajnamekar25,

I can't see the "Series" section under my format visual. I am using the Line and Clustered Column Chart.