Data Rounding

[KirtiSingh]

Hello everyone,

I'm currently facing an issue with data rounding. In the actual data which is in SQL server Mgmt Studio, the values are rounded up to 15 decimal places, however, when I bring this data into Power BI, the fields are automatically rounded to only 2 decimal places. I've attempted to update the data in Power Query, but the visualization still shows data with only 2 decimal places.

For example:

Value in SSMS - 2.569872361510065

Value appearing in Power BI - 2.6

I'm wondering if there's a way to show the exact data in the same format as in the backend?

Your help on this would be greatly appreciated. Thank you!

[Gowtham_Selvam]

Format your visual --->callout value ---> Display unit as none.

If I answered your question,mark it as solution.

[Ahmedx]

i think you need to convert them to text. then there will be no rounding
and
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings