Forum Discussion
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
do it like in the screenshot
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
- Ahmedx
Super User
do it like in the screenshot
- BeingAslamFrequent Visitor
Hi Ahmed this is solution not work properly, suggest another.
- Ahmedx
Super User
explain why it doesn't work
- Ritaf1983
Super User
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
- BeingAslamFrequent Visitor
Hi Ritaf this is solution not work properly, suggest another.
- Ritaf1983
Super User
This solution should work perfectly according to the description,
If it is not, please share the dummy file to check why.