Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Saraneno

Rounding Error (Some are rounded up and others are rounded down)

Submitted by on ‎06-09-2022 07:29 PM

I have a problem in rounding in formatting on Power BI.

Some are rounded up and others (1 record) are rounded down when I set Percentage as Format and 1as dicimal place on formatting.

For instance, there are 156.250000% and 118.750000% and when I set the formatting as above, 156.250000% turns into 156.3% while 118.750000% turns into 118.7% which I think is wrong.

Anyone has any idea to fix this or why this is happening?

Acutal values which have issues

Saraneno_0-1654828112300.png

Saraneno_1-1654828122240.png

 

Status: Investigating

I have created a matrix with two rows data and a sum measure to show it, but it looks like normal:

vyingjl_0-1655100656593.png

Whether you can share your measure which is used to calculate the value

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
4 Comments (4 New)
Comments
v-yingjl
Community Support
Community Support
‎06-12-2022 06:24 PM
Status changed to: Needs Info

Could not reproduce it in my side as far as my test. Basically Power BI Desktop should have the same rule on round format. Perhaps you can consider providing more details about this issue:

  1. The version of Power BI Desktop(test version: 2.105.1143.0)
  2. How did you get the original data and the rounded data, enter the original data manually and create measure to get to format it or else?
  3. Which visual you have used in this issue and how did you create it in details

 

Best Regards,
Community Support Team _ Yingjie Li

Saraneno
Regular Visitor
‎06-12-2022 09:57 PM

Thank you very much for your response. Here are the more details about this issue.

 

  1. The version of Power BI Desktop(test version: 2.105.1143.0)
    →My version is 2.105.1143.0.
  2. How did you get the original data and the rounded data, enter the original data manually and create measure to get to format it or else?
    → As you said, I loaded the original data and create a meacure to calculate it and then change the formatting to set the decimal place.
  3. Which visual you have used in this issue and how did you create it in details
    → Matrix by defalt.
v-yingjl
Community Support
Community Support
‎06-12-2022 11:11 PM
Status changed to: Investigating

I have created a matrix with two rows data and a sum measure to show it, but it looks like normal:

vyingjl_0-1655100656593.png

Whether you can share your measure which is used to calculate the value

 

Best Regards,
Community Support Team _ Yingjie Li

Saraneno
Regular Visitor
‎06-20-2022 11:33 PM

Hi Yingjie,

 

Thank you very much for your reply.

Since this is output to be presented to our client, I also asked Support Center (Premier) and got information from them so I will get in touch with them. If it is solved, I will share why it happened and solutions for that.

 

Best regards,

 

Sara

Idea Statuses