color text by expression

[mhapanka]

If I have a measure as a master item called (Country missing) and I have used this as a measure in my pivot table, how do I ensure that the if this measure is greater than 0 the text in the pivot table is red and green if not ?

[william_fu · Accepted solution]

Go to your measure in the pivot table options, and edit the text color expression to something like

If([Measure] > 0, red(), green())

[michaelsikora]

Click the plus by the dimension or expression (depending on what you want to be green). Then double click on the "Text color" and type this:

if(Measure > 0,RGB(0,128,0),

RGB(230,0,0))