Combination Chart Error in Y axys

[moliveira-GA]

Hello everyone, 

I need your help to solve an issue that appears to be a bug (or the bug is me 😂). 

I have this combination chart with compares 3 measures: Actual revenue, Budget revenue and Prior Year's revenue. Actual and Prior Years are columns, budget revenue is a line in the chart. For only one of our products, there is no data as prior year's revenue and actual revenue starts at may (the X axys shows months). 

The problem is: actual revenue is $0,02MM and budget revenue is around $0,19MM. Of course, the actual revenue's column should be less than the line, but it's not happening that way, as you can see below. Important: all axes are set to "auto" (I already tried setting the minimun value to zero, but whitout success. Have you seen that before?

thanks in advance!

[moliveira-GA · Accepted solution]

Hello Neeko, 

thanks foi your reply, but the problem persists, as you can see below:

But, I solve the problem by re-doing the entire chart. It appears to be an issue related to the two measures in the columns (one represents the actual revenue while the other shows the revenue from prior year). 

Testing different business, it seems to be solved that way. 

[v-tangjie-msft]

Hi @moliveira-GA ,

If you want their y-axis scales to be consistent, you can click [format your visual]->off [secondary y-axis].

Best Regards,

Neeko Tang

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