Forum Discussion
Power BI not recognising numerical values
Dont worry - Power BI is being buggy - sorted.
Power BI team, if you want to look into bug - chronology:
Uploaded excel file (4 text cols + 1 numerical col)
Conditional formatting wouldnt work (numerical column not recognised as numbers - could only conditional format if the count option was on)
I noticed that the uploaded file for some reason had an additional blank row loaded into dataset.
(*) Deleted blank row, saved excel, refreshed Power BI - numerical column still not recognised as numbers (blank row had disappeared).
(#) Started new Power Bi file, imported excel, numerical column recognised as numbers, conditional formatting works.
Between (*) and (#) i did not do any changes to excel file. Maybe in the refresh stage Power Bi failed to reconise change.
Hi anandmarsh,
I have made some test based on your chronology. However I cannot repro your issue. By the way I'm using Version: 2.56.5023.1021 64-bit (March 2018) Power BI Desktop.
What's your Power BI Desktop version? You can check it at File -> Help -> About.
Also, please share us a sample Excel file which can help us repro your issue.
Thanks,
Xi Jin.I am using Version 2.56.5023.1021 64-bit (March 2018).
The problem arises when the data is imported. It wont recognise values (even though they are recognised in excel as values)
Refer images - ignore blue squares - I have to block out data (confidential).
1) excel will filter values in ascending/descending (it recognises values)
2) power bi says that the values are "abc123"
3) I have to "Change Type" to numeric
4) power bi says that the values are "123"
1)
2)
3)
4)
I am using Version 2.56.5023.1021 64-bit (March 2018).
The problem arises when the data is imported. It wont recognise values (even though they are recognised in excel as values)
Refer images - ignore blue squares - I have to block out data (confidential).
1) excel will filter values in ascending/descending (it recognises values)
2) power bi says that the values are "abc123"
3) I have to "Change Type" to numeric
4) power bi says that the values are "123"
1)
2)
3)
4)
Hi anandmarsh,
What's the data type of this column in Excel file? According to your first screenshot, it seems like it is a General type.
You should know that in Power BI, there's no General type column. So for the first time you load your excel into Power BI. It will define this column as text type since it is General in Excel.
Then once you created a dataset in Power BI, the data type of each column would be defined and these column types will not be changed automatically. It also means that even you refresh both the Excel file and the dataset, the column type is still text. You have to "Change Type" manually.
Or change the column type to numeric at the begining in Excel file. And create a new Power BI report.
Thanks,
Xi Jin.
