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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
mina97
Helper III
Helper III

sum showing as 6.76E+18

i tried to show the summation of my coulmn as a card buth this what appears in the dashbored 6.76E+18 

can you help show the full number

1 REPLY 1
BA_Pete
Super User
Super User

Hi @mina97 ,

 

Power BI can only display numbers up to 19 digits of significance. This would be an integer of 19 digits, or a decimal number of 15 digits and 4 decimal places.

The value you're trying to display is 19 digits if it's an integer, but I suspect it's actually a decimal value, therefore you're expected output will actually be 23 digits in the background.

Either convert your value to an integer data type, or think about truncating it to a factor of K/M/Bn/Tn etc.

More information:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-types 

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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.