Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Changing data type to numeric values

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 don...
Data Protection
  • Anonymous's avatar
    Anonymous
    4 years ago

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

    regards

arichard19's avatar
arichard19
Resolver I
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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.