Forum Discussion
Data type concern
I am currently having an issue on Power BI. I have brought specific data from Excel and imported them into Power BI. When I try to insert my specific "Hour" data type and make it a table visual, the data type is not the appropriate way. The hours should be in a decimal data type but show up in whole number format in the table. I have listed images in the bottom. The image in the top , specifically the left hand table with the hour coulmn data is the one I am having an issue on. The data appears as whole numbers yet in the data view, it is a decimal format. I would like my hours coulmn to be in decimals.
The table on the left hand is the one I am having an issue with, specifically the hour column data.This image shows the hour coulmn data and how the data should look like, it is in decimal format.
Hi reyesjosue ,
You can also change the date type for measure in the same place. Or you can change the it in the screenshot below:
Best Regards,
Dedmon Dai
6 Replies
Can you provide the code for the measures or calculated columns you are using? Often time loss of precision in a data type is because it is being calculated with another field or constant that has lesser precision, and the result takes on the lowest amount of precision.
Hi reyesjosue ,
I can't reproduce your mistakes. To do this, I would have to get an excerpt from your data. Is that possible?Regards FrankATI am using the appropriate data set labeled "Hours"
Hi reyesjosue ,
You can also change the date type for measure in the same place. Or you can change the it in the screenshot below:
Best Regards,
Dedmon Dai
looks like your aggregatin is set to Do Not Summarize, so when you pull Hours into a table it does Count and Not Sum, so since i cannot see how the table is set up, is it possible that you are looking at the Count of hours and not individual hours?
