Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Target Met conditional formatting

If target <=Actual then Actual value show show in Green font/ background color else Red Thanks.
Need Help
  • richbenmintz's avatar
    richbenmintz
    6 years ago

    Hi Anonymous,

    Create a Measure that returns the Hex Code you want to apply to your Back/Font Color, then use the Field Value option when setting up conditional formatting

    back color = if([target]<=[actual], "#008000", "#FF0000")

    Hope this helps,

     

    Richard


    Did I answer your question? Mark my post as a solution!
    Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up! 

richbenmintz's avatar
richbenmintz
Resident Rockstar
6 years ago

Hi Anonymous,

 

You would use the conditional value by value option

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

 

 

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    6 years ago

    Hi @sbhan4,

    The Value needs to be a string that represents the color, like the back color measure created

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      richbenmintz 

      Thanks for your help!. It's not working. I have created a Black color measure. How to use that column for conditional formating.

      Could you please try it in power bi workbook for me.

      If Target is < Actual - red color font

      if target >= Actual - Red color font

       

      • richbenmintz's avatar
        richbenmintz
        Resident Rockstar
        6 years ago

        Hi Anonymous,

         

        Have a look at this .pbix, sample.pbix , it contains a conditional formatting measure.

         

        Hope this Helps,

        Richard


        Did I answer your question? Mark my post as a solution!
        Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!