cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to fix Y axis scale

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:

Karolina_0-1594041736112.png

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?

6 REPLIES 6
Highlighted
Super User VII
Super User VII

Re: How to fix Y axis scale

@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?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper I
Helper I

Re: How to fix Y axis scale

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_0-1594043230471.png

 

Highlighted
Super User VII
Super User VII

Re: How to fix Y axis scale

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

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper I
Helper I

Re: How to fix Y axis scale

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. 

Highlighted
Microsoft
Microsoft

Re: How to fix Y axis scale

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.

Highlighted
Helper I
Helper I

Re: How to fix Y axis scale

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors