Conditional ´formatting for negative values (plus why the HELL does CF result in a total????)

[inservo]

Man, the guy over at MS who is repsonsible for UX should be severly punished. 

I don't know of any other tool that lets me jump through so many burning hoops.

I have a column that holds a percentual value (calculated that in KNIME as it just a pure PitA to do it in PBI) and I want it to be displayed with a red icon, if the value is below 0. If it is zero it should be yellow, if it is above zero it should be red.

Numerous other tools can do that, but the oh so cool PBI can't. What a pain.

[lbendlin]

so it should be red-yellow-red ?  should the text be that color or the icon?

[inservo]

no, I misspelled my above entry. It should be red - yellow - green

< 0 % = green

= 0 % = yellow

> 0 % = red

Preferred as icons

[lbendlin]

see attached