Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional Formatting Not Working

Hello all,   First off I am new to Power BI so if this is a simple explanation I apoligize. I tried googling and could not really find a solution.   I have a table vizualization that I would like...
Need Help
  • Vvelarde's avatar
    Vvelarde
    6 years ago

    Anonymous 

     

    Yeahh, you have Row with Spaces in that column you need to cleaned before.

     

    One way is create a new Column :

     

    DaysOpennedModified=IF(ISERROR(VALUE('HR'[Days Openned])),BLANK(),'HR'[Days Openned]) , now this column you can change to Whole Number.

     

    Regards

     

    Victor

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you Vvelarde 

 

I tried this, when I try to covert it to whole number I get the error "Cannot convert value '' of type Text to type Integer."

 

Any suggestions?

 

Thanks

Vvelarde's avatar
Vvelarde
Community Champion
6 years ago

Anonymous 

 

I will checked if your columns Days Open had Text Character in any row , like Letters, Spaces or anything that can't transform in Integer Type.