How to fix Y axis scale

Question

I have made two visuals showing the total number of orders and in both the totals are the same per date, but the scale in the y axis doesn't show that, for one it shows almost double the amount:

When I hover to show the tooltip, they have the same amount in all the dates, which is what is expected, but the Order Count axis numbers are wrong, how can I fix that for the visual on top as the bottom one seems to be right?

parry2k · Answer

Karolina&nbsp;I know the total should be the same whatever dimension you used, the question was more about if there is any filter and sees like that is not the case. Are you using any measures? Did you manually change the y-axis min and max values? Maybe it is a bug, trying to find out what could cause this. Can you try to create a new visual and check if it still gives you 600k as the upper limit.
&nbsp;
&nbsp;

karolina · Answer

//Posting this because it may help others

So I fixed this by creating a custom column where I basically only used countries where the count is more than 10 (in this case acceptable to ignore) and using that column of country names instead of the original one... somehow this made the y axis show the right numbers, so this is completely a workaround that makes the axis un-confused somehow.
I know it is not a good fix, and I think this is a bug in powerbi, but for now taking the time to clean the data and sending in a pbix to fix this is not a priority.

parry2k · Answer

Karolina&nbsp;not sure I fully followed your question, what is the legend in both the visuals? Can you use matrix visual and check the numbers? Are you using any measures? Are you using any filters on the visuals?

karolina · Answer

The legens are different for both visuals but the totals in the same date should be the same no matter the dimensions I use.
For the top one the legend is country and the bottom one is product (colored out). I am not using any custom measures and I have the exact same filters in both of them (a date range).

The problem is that the y axis in the top visual is not showing the right numbers, as shown in the image, the tool tip has a value of 1.5M (total orders), but the y axis (also total orders) shows 600k, which is clearly incorrect

karolina · Answer

Hi parry2k, sorry for the late reply, but yes, I have created the same visual in 2 different documents at first and noticed the differences. Then created them side by side so I can compare, and every time with the country dimension it gets the same axis, even on different types of visuals.I have not set the limits of the axis manually nor have I used custom measures.&nbsp;

Forum Discussion

How to fix Y axis scale

6 Replies

Related content

Warehouse Scaling

y axis scale

Set max for y-axis scale in Radar Chart

Error with y-axis max scale adjustment

Automatic scaling on Y axis