Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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