Power BI rounding up figures in one column

[zina-aziz]

Hi,

I have a column with figures containing one decimal place in excel. When I import the data into power BI, only that one column is rounding up and now showing the decimal figures. I have amended the column in the data tab and in the query editor to be Decimal number and specified one decimal place, but still not working. Any ideas why power bi is rounding it up?

[v-shex-msft]

Hi @zina-aziz,

Which connector you used to get data from excel, odbc or excel connector? I test to use excel connector to get data from some sample data but can't reproduce your issue.

I'd like to suggest you enter to query editor to check column types if power bi hasn't correct analysis your column type to decimal.

BTW, you can also try to use round functions to rounding up your records.

Power query Rounding functions:

Function	Description
Number.Round	Returns a nullable number (n) if value is an integer.
Number.RoundAwayFromZero	Returns Number.RoundUp(value) when value >= 0 and Number.RoundDown(value) when value < 0.
Number.RoundDown	Returns the largest integer less than or equal to a number value.
Number.RoundTowardZero	Returns Number.RoundDown(x) when x >= 0 and Number.RoundUp(x) when x < 0.
Number.RoundUp	Returns the larger integer greater than or equal to a number value.

Dax functions:

ROUND Function (DAX)

ROUNDDOWN Function (DAX)

ROUNDUP Function (DAX)

Regards,

Xiaoxin Sheng