Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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.
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.
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.
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?
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?
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.
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |