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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors