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,

 

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!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

@richbenmintz Perfect!! It was helpful.

if(COALESCE([Val 1]<[Val 2], [Val 1]<[Val 3], [Val 1]<[Val 4])= BLANK(), "#FFFFFF", "#008000")
If i have tons of records not only 4 rows, in this case can i use if(COALESCE([Target]<=[Actual],"#FFFFFF", "#008000") now where to use BLANK
  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    6 years ago

    Hi Anonymous,

     

    Assuming [Target] and [Actual] are measures, you would likely use

    if([target]<=[actual], "#FFFFFF", "#008000")

    The Coalesce in my example was a shortcut for an 'Or' condition, essentially checking to see if any of the cases evaluated to true().

     

    Richard