Forum Discussion
Rangapbi
9 years agoRegular Visitor
PowerBI not taking decimal values
Hi, When I am adding decimal values in data source(MS excel) power bi not takinhg it as it is(0.4,0.5,0.6 etc..) giving only 0.
GilbertQ
9 years agoSuper User
Hi Rangapbi
Go into the Query Editor and make sure that for your column the dataset is changed to either Decimal Number or Fixed Decimal
Due to the way the Query Editor works with a sample of the first 100 rows if there are no decimals it might defaulted it to a Whole Number.