Decimal point issue

[Punitha]

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	High Price	Low Price	Last Price	Close Price
TATACHEM	EQ	16/Oct/18	649.8	657	687	654	676	676.55
TATACHEM	EQ	17/Oct/18	676.55	678.2	686.6	663.75	667.7	670.1

[Punitha]

While transforming the decimal turned into whole . I mean without decimal it showing. I tried fixed decimal and decimal too but not fixed solution.

[quentin_vigne]

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