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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Decimals are not showing correctly on Power BI report page

When I transfer my data to Power BI apps, the decimals are not being maintained the way it should be. Power BI app shows the number as multiplied by 100 automatically. For instance:

0.06 actually shows as 6.00
Similarely 123.45 shows 12345.00

Numbers without decimals are not affected by multiplying.
so if the data has numbers WITH decimals and WITHOUT decimals, then then output is gettng somewhat mixed.

Does anyone knows about this issue?
Any help would be appriaciated!

Thanks,
Mithlesh

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @mithlesh,

 

I'm not able to reproduce the issue on my side. Please try below options: 

 

1. Check if the issue only happen to this specific report or all reports. 

2. Try to update the Power BI desktop to the latest version 2.52.4921.581 64-bit (November 2017), then republish again. 

3. In Power BI service, download the published report and open in Power BI desktop, check if the decimal number is same as in Power BI service. 

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Needs Info