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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ABNHS84
Frequent Visitor

Changing type adds decimal places to value during import of Excel file

We have an Excel file that has a list of percentages in 'General' format. The data can be one of 1 decimal place, 0 decimal places, or it is an asterisk due to being suppressed. 

 

The problem we're encountering is that when we change the type of this column from 'ABC over 123' in Power BI (my apologies I don't know, and can't figure out what data type this signifies) to Text datatype (just ABC in the column heading) a handful of values (from a list of thousands) have a Very small number added to or subtracted from them, resulting in really long decimals. E.g.

66.1 becomes 66.099999999999994

64.9 becomes 64.900000000000006

40.2 becomes 40.200000000000003

 

The numbers appear correctly for the 'Applied Steps' prior to 'Changed Type'

 

I have no idea why Power BI would do this, and what we can do to remedy it, so any help greatly appreciated. 

 

1 REPLY 1
ibarrau
Super User
Super User

Hi. Continue and apply changes leaving the field like that. Then you can pick a format for columns under "Modeling" tab. Go to Data view and select the column. Then you can see what I mean. For example:

Modeling decimalModeling decimal

 

You can change Decimal number values in right side of coma. My value is 2 for UnitPrice. Check out how the column looks like after that change.

 

Hope this helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.