How to fix Y axis scale

[Karolina]

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?

[Karolina]

//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.

[V-lianl-msft]

Hi @Karolina ,

The issue could be caused by the legend field.

Could you share the sample pbix via cloud service like onedrive for business?

Please mask any sensitive data before uploading.

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

[parry2k]

@Karolina 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]

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

[parry2k]

@Karolina 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.

[Karolina]

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.