Last few digits get round off automatically in a 19-digit number in matrix

[mohit_K]

For X field the value shown in a matrix is 320,809,350,774,508,000.0 whereas the value in the Postgres database appears to be 3208093507745086792.456.

For another Y field the value shown in a matrix is 3,208,093,507,175,300,000.0 whereas the value in the Postgres database appears to be 
3208093507175299731.203.

Although a field Z with 17 digit number doesn't get automatically rounded up and displays exact value

The values should not get rounded up automatically.Please let me know if there's a solution for this.

[Anonymous · Accepted solution]

Hi @mohit_K 

What is your data type ?

Decimal Number- The largest precision that can be represented in a Decimal Number type is 15 digits long. The decimal separator can occur anywhere in the number.

Fixed Decimal Number – Has a fixed location for the decimal separator. The decimal separator always has four digits to its right and allows for 19 digits of significance.

More info about the data accuracy in Power BI can refer to the link :

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

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.