Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
dogt1225
Helper II
Helper II

Decimal Data Type Rounding Up

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:

SQL2.PNG

 

PowerBI:

Picture1.png

1 ACCEPTED SOLUTION
vivran22
Community Champion
Community Champion

Hello @dogt1225 ,

 

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

 

image.png

 

Cheers!
Vivek

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

View solution in original post

2 REPLIES 2
vivran22
Community Champion
Community Champion

Hello @dogt1225 ,

 

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

 

image.png

 

Cheers!
Vivek

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

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!

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.