Re: sum showing as 6.76E+18

mina97 · ‎09-13-2023

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

BA_Pete · ‎09-13-2023

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!