Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Rounding issue on Graph totals

I was confused by my Power BI graph and thought my data was wrong but realised the total value in the graph is very unusual. I have a graph showing resource cost month on month, broken down into categories. At the top I have a data value for the total and Power BI is rounding it to the nearest £1M which is very wrong. 

 

In the month of December the total cost was £508K, which Power BI is rounding up to £1M! How do I change the total data points to round to nearest 100k, or show like the other data points. The graph is very confusing showing £1M

 

chrisingham05_0-1620809040668.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Oh actually I think I have just fixed it, in the graph formatting it seems there is different formats for data labels and total labels. Changing the decimal places from 0 to 1 has fixed the issue

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Oh actually I think I have just fixed it, in the graph formatting it seems there is different formats for data labels and total labels. Changing the decimal places from 0 to 1 has fixed the issue

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors