Changing data type to numeric values

[Anonymous]

Hi everyone

Can someone assist me here please.

I have 4 columns with numbers on Excel. I even manually change the data type to numbers on Excel.

But when I load this spreadsheet on power bi, I dont see the summation symbol that indicates a numeric type of the field next to the columns names. enevn after tranforming my columns in power querry I still don't have that, and I can plot these data.

what should I try?

Your asssistance will be highly appreciated.

@datatype

[Anonymous · Accepted solution]

Thanks for your feedback. I just opened a new pbi file and the problem disappeared.

regards

[arichard19]

Make sure you have selected the correct data type when importing the data into Power BI within Power Query -
https://docs.microsoft.com/en-us/power-query/data-types

If you have, the simply use a Dax measure which sums your decimal or whole number columns =

Sum = Calculate(Sum(Column[1]))

Then you will be able to plot the values

[Anonymous]

Hi, Thanks a lot for your prompt feedback. 

I simply opened a new pbi file and managed to import the table with the correct format.

I think there was a problem with te first file, I'm wandering what could that be.

Thanks

[Anonymous]

Hi @Anonymous ,

There should be some thing wrong when you load data from Excel. 

Could you tell me what kind of data type will the columns from your first file work like, text or others? Please show me a screenshot with your column type in first file.

I think you can change the data format in Power Query Editor and Column Tools in Report View. Or you can delete the data model and load it again.

Best Regards,
Rico Zhou

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