Forum Discussion
Decimal point issue
Hi, While loading data from excel file to power bi. Decimals turned into round number. My data is price of product so how to fix it. Excel Data Symbol Series Date Prev Close Open Price Hi...
Hello Punitha,
First of all, depending of your region Power BI use "." or "," as decimal separator.
You can still use the "Transform data" option to replace all your "." in decimal fields to "," in order to be able to use the decimal formating.
I hope this will help you find the right solution.
- Quentin