Data type concern

[reyesjosue]

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.

[andre]

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?

[Anonymous]

Can you just check that the column you have displayed in picture 1 is the "Hours" column from the data set labelled "Hours" and not from the dataset labelled cost to complete 

[reyesjosue]

I am using the appropriate data set labeled "Hours"

[v-deddai1-msft · Accepted solution]

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

[FrankAT]

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 FrankAT

[dedelman_clng]

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.