Forum Discussion
Target Met conditional formatting
If target <=Actual then Actual value show show in Green font/ background color else Red Thanks.
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!
Thank you for your solution. Now I got one measure with color code. How can I use this with conditional formating so font or background of Target color should get.
Hi Anonymous,
You would use the conditional value by value option