Decimal Data Type Rounding Up

[dogt1225]

Hi All --

I have a decimal data type that is automatically rounding up to the nearest integer. For example in the last row, the data source has 14.5, but in Powerbi it is 15.0 . I would like to show the number from the datasource (14.5). Any ideas on how to fix this? 

Data Type = Decimal
Format = Decimal

Formatted to 1 decimal place

DataSource:

PowerBI:

 

 

[vivran22 · Accepted solution]

Hello @dogt1225 ,

What is the data type assigned in Power Query editor? Please check if it is a decimal or whole number.

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[dogt1225]

Ah! This gets me every time.. I change the data type in the Report tab, but forget to change in Power Query Editor. 

Thanks you for the help!