Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional color formatting

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 

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    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)

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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)

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous 

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