Hi everyoneCan 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

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

Changing data type to numeric values | Microsoft Fabric Community

Anonymous
Not applicable
4 years ago
Thanks for your feedback. I just opened a new pbi file and the problem disappeared.
regards
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
  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
    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.