Conditional color formatting

[Anonymous]

Hello,

This is my dummy data. I want to show if [Actual Target] < Target then "Red" else "Green" as shown in the screenshot. Can someone help me? Here is the link for my excel sheet. 

https://drive.google.com/file/d/1OpnOTi_Y1gvBIg8D0FCvTFHipUCR3kuu/view?usp=sharing 

[harshnathani]

Hi @Anonymous ,

Create a measure

Condition = IF (MAX('Table'[Actaual Target]) > MAX('Table'[Traget]),1,0)

Then

Go to 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

@harshnathani 

Thanks for your quick solution. Could you plz share your pbix file with me?

[Anonymous]

Thanks for your quick solution. Could you plz share your pbix file with me?

[harshnathani · Accepted solution]

Hi @Anonymous ,

File attached.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)