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

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous can you remove first blank() condition and then check, wondering if you are having blank values.