Forum Discussion

zina-aziz's avatar
zina-aziz
Frequent Visitor
8 years ago

Power BI rounding up figures in one column

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?

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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