Forum Discussion
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
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
Ritaf1983
Super User
Super UserHi 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
Hi Ritaf this is solution not work properly, suggest another.
- Ritaf1983
This solution should work perfectly according to the description,
If it is not, please share the dummy file to check why.I have a measure which is adding current year sales minus last year, but when I apply filter then this condition is not working properly.