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

Before I try to change to whole number:

 

After I change to a whole number:

Vvelarde's avatar
Vvelarde
Community Champion
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

    This is exactly what I needed, thank you!!! 😁