How to align the Secondary Y axis with the Primary Y axis

[Ibrahim_shaik]

Hi Power Bi Community,

I have a column and line chart and I have added the secondary Y axis but the values doesn't align with the Primary Y axis and it looks a bit off.

how to align both the axis.

please give a solution.

Thanks & Regards,

Ibrahim.

[RossEdwards · Accepted solution]

The other suggestion i could make is forcing each primary and secondary axis to have set max and min values. That way you could detirmine what the interval sizes would be using a ratio.

[v-jiewu-msft · Accepted solution]

Hi @Ibrahim_shaik ,

First of all, many thanks to for your very quick and effective replies, and I will give some additions below:

1.Create the sample table.

2.Drag the Year into the X-axis, drag the score into the column y-axis and drag the measure into the line y-axis.

3.Set the Y-axis maximum same with the Secondary y-axis and turn on the Align zeros.

4.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019]

Hi @Ibrahim_shaik 

Based on you units it defines the ranges on y axis. 
I have taken same value on bar and line chart.

It is properly displaying the unit ranges.

Let me know what exactly issue you are facing?

[RossEdwards]

I'd recommend disabling the secondary axis.  This will force the graph to align everything to the primary axis.

I'm assuming thats what you are trying to do?

[Ibrahim_shaik]

Hi @Uzi2019 , @RossEdwards ,

In the image that i have posted you can see values 10, 20, 30 are not aligned to the primary axis grid line only 0 and 50 values are aligned. 

I want to align all the values.

[RossEdwards · Accepted solution]

The other suggestion i could make is forcing each primary and secondary axis to have set max and min values. That way you could detirmine what the interval sizes would be using a ratio.

[Ibrahim_shaik]

Hi @RossEdwards ,

Sorry for the delayed reply.

Yeah as you said if i set the min and max values of both the y axis and Secondary y axis then the values align properly with the grid lines.

But my issue i cannot set both the axis min and max Y axis should be dynamic that is Auto and for Secondary Y axis i have to set min and max values.