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

         

  • pranlad's avatar
    pranlad
    New Member
    6 years ago

    my conditional formatting not working for column however same formatting working fine for another column with same data type

    • pranlad's avatar
      pranlad
      New Member
      6 years ago

      I have used Divide() function to arrive at % value