Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Reference table keeps rounding numbers

Hello,   I have a referenced table that contains an age column. In the Source table the age column is decimal example: 49,9, While in the referenced table column Age shows 50.   I have checked a...
Data Protection
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello,

     

    Thanks for the reply, I have figured it out.

     

    It shows that when I load data from the PQ, automatically its rounding it up because I didn't set data type as Decimal in PQ before loading.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

After you loaded the data, select the referenced table in Data view of Power BI Desktop, then select the Age column and click on Column tools tab. Make sure that its Data type is Decimal number, its Format is Decimal number too and the number of decimal is not 0. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

     

    Thanks for the reply, I have figured it out.

     

    It shows that when I load data from the PQ, automatically its rounding it up because I didn't set data type as Decimal in PQ before loading.