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
Icon for Solution Sage rankSolution Sage
8 years ago

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.

RC8's avatar
RC8
Regular Visitor
8 years ago

I am experiencing a similar issue but the symptoms are a bit different.

 

If I create a matrix with numeric values I can access the conditional formatting features.  However, if I wrap the values in the FORMAT function and use "Percent" as the format, the conditional formatting options disappear as if Power BI no longer believes these are numeric values.  Is anyone else experiencing this issue?