Sign positive in value of the measure

[DR2022]

Hi! I coded a conditional measure inside a SWITCH function to color the values. For negative values ​​it turns green, as it is a tax reduction. On the contrary, for positive values ​​it turns red, as it is tax increasing. For 0 it turns grey. But I would like the plus sign (+) to also appear in front of the number as well as the minus sign, to accentuate the increase. I am not able to do this in the measure. 

Conditional1 = SWITCH(TRUE(), [VarUltVlr]<0,"Green", [VarValue]>0,"Red", "Grey")

 

[Bifinity_75 · Accepted solution]

Hi @DR2022 , try to create a new measure:

New Var = IF ([VarUltVlr]<0,[VarUltVlr],
                IF ([VarUltVlr]>0,"+",0))

Best Regards

[DR2022]

It works! I created a new measure but I put / "+"&FORMAT([VarUltVlr], "Percent") / as value if true. The second IF it was not necessary.

Thank you very much!