Forum Discussion

anandmarsh's avatar
anandmarsh
Regular Visitor
8 years ago

Power BI not recognising numerical values

Hi All,   I have displayed some data from the excel file into a table in Power BI.    4 columns are text 1 column is nummerical   Power BI doesnt recognise the numerical values (i.e. i cannot ...
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

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.

anandmarsh's avatar
anandmarsh
Regular Visitor
8 years ago

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)