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.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I removed the rule related to blank values and still nothing

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

    Anonymous can you drop your measure that one you are using for conditional formatting in a table visual and see what result you are getting. without seeing the data it is hard to say what is going on. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I added it to a new vizualization and now it is only working for a few of the values, very strange

       

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

        Anonymous are you showing cout of days opened in your image which doesn't seems to be the case because it doesn't looks like a number.