How can I adjust automatically the axis of a chart of grouped columns and lines?

[Anonymous]

Good morning everyone,

I know this can be adjust automatically not selecting any beggining or end in the axis settings  but I have found the following problem:

• As you can see in January, the value for the line is 6 while for the column is 4 but the chart is displaying the column over the line when it's value is lower and the same happens in every month until August.

I have tried to set the beggining and the end of both axis with the same permanent value but this solution isn't possible since the values vary every week.

Could anyone help me to fix this problem?

Many thanks in advanced

Adrian

[dax · Accepted solution]

Hi APASTORM,

It seems that you want to adjust the y-axis's range to be same, right? As I know, it will adjust automatically, we couldm't change its intervel. So I think you could use onle one y-axis, you could close secondary axis like below

Best Regards,
Zoe Zhi

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