Forum Discussion

BeingAslam's avatar
BeingAslam
Frequent Visitor
2 years ago
Solved

Card Value Negative red and Positive Green

Dear friends, I want my value to turn red when it is negative and green when it is positive.

This value is current year - (minus) last year

 

 

Regards

  • Hi BeingAslam 
    You can create a measure like :

    flag = if (sum('Table'[value])> 0,1,0)
    And then modify the conditional formatting of the card value according to this measure :

     

    Result

    PBIX is attached

    Please note :
    it is not recommended to use traffic light colors to emphasize messages, as people with color blindness do not see a difference between red and green. Therefore, it is recommended to use combinations of blue and red, and not green and red.
    For more information about color issues please refer :
     
     

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

10 Replies

    • BeingAslam's avatar
      BeingAslam
      Frequent Visitor

      Hi Ahmed this is solution not work properly, suggest another.

  • Hi BeingAslam 
    You can create a measure like :

    flag = if (sum('Table'[value])> 0,1,0)
    And then modify the conditional formatting of the card value according to this measure :

     

    Result

    PBIX is attached

    Please note :
    it is not recommended to use traffic light colors to emphasize messages, as people with color blindness do not see a difference between red and green. Therefore, it is recommended to use combinations of blue and red, and not green and red.
    For more information about color issues please refer :
     
     

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

    • BeingAslam's avatar
      BeingAslam
      Frequent Visitor

      Hi Ritaf this is solution not work properly, suggest another.

      • Ritaf1983's avatar
        Ritaf1983
        Icon for Super User rankSuper User

        This solution should work perfectly according to the description,
        If it is not, please share the dummy file to check why.