cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarlaP Frequent Visitor
Frequent Visitor

SOME decimal places not showing in data

I have combined two csv files to power BI and unpivoted the colums Monday to Sunday, named to Week Day and the values to Total Hours.   In some instances the data does not show the entire number: on original csv file shows 2.5 but on data model only 2; on csv. is 1.25 but shows 1, etc. 

I have changed the format  of all column to decimal, 2 cases, the local... replacing the values on the cell itself is not an option as  a new csv file with more rows added need to be uploaded to the model.

 

I tried to solve this by to get data from excel format, not combining files and not unpivot the columns columns, and I still get the incorrect total hours. Any suggestions to resolve this would be much appreciated. 

 

Capture1.PNGCapture2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
affan Established Member
Established Member

Re: SOME decimal places not showing in data

Hi @CarlaP,

 

You are facing this issue becuase when you get data from csv it asks how to do the detect data type. By default it is "Based on firs 200 rows".
Becuase your top 200 rows in Saturday and Sunday do not have any decimal value, it assigns them Whole number data type

Data Type Dtection.png

 

 

Change this to Do not detect data types and Load. Then go to Edit Queries and manualy change the data types. See the video I made for you below to see how to set the data types once you have got the data in power bi.

 



If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

 

View solution in original post

5 REPLIES 5
affan Established Member
Established Member

Re: SOME decimal places not showing in data

Hi @CarlaP

 

Share your CSV file so that I can help you on this

Community Support Team
Community Support Team

Re: SOME decimal places not showing in data

Hi CarlaP,

 

Couldn't reproduce your issue on my side. Could you share your sample data for further analysis? In addtion, you may save your pbix file as excel file and then import the excel file into power bi and check if it can meet your requirement.

 

Regards,

Jimmy Tao

CarlaP Frequent Visitor
Frequent Visitor

Re: SOME decimal places not showing in data

Highlighted
affan Established Member
Established Member

Re: SOME decimal places not showing in data

Hi @CarlaP,

 

You are facing this issue becuase when you get data from csv it asks how to do the detect data type. By default it is "Based on firs 200 rows".
Becuase your top 200 rows in Saturday and Sunday do not have any decimal value, it assigns them Whole number data type

Data Type Dtection.png

 

 

Change this to Do not detect data types and Load. Then go to Edit Queries and manualy change the data types. See the video I made for you below to see how to set the data types once you have got the data in power bi.

 



If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

 

View solution in original post

CarlaP Frequent Visitor
Frequent Visitor

Re: SOME decimal places not showing in data

Amazing, thank you very much!

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)