Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issues with Conditional Formatting for calculated measures

Hi friends, I tried but couldn't figure it out, I have this calculation below which i would like to 1. add the "+" sign for positive variance. so made the change (in red) for my formula and it retu...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Please try formula as below:

    calculated column:

    Operating Surplus_CY =
FORMAT (
    CALCULATE ( SUM ( Sheet1[Value] ), 'End Year'[End Year] ),
    "+#,##0,.0M;-#,##0,.0M"
)

    measure (conditional formatting)

    Conditional fomatting =
IF (
    [Operating Suplus CY] > 0,
    "lightgreen",
    [Operating Suplus CY] < 0, "red" )
)

     

    related document:

    Custom numeric formats 

     

    Best Regards,
    Community Support Team _ Eason

     

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

 

Operating Surplus_CY =

VAR OP_CY =
CALCULATE(
SUM(Sheet1[Value]),
'End Year'[End Year]
)

var _2 = format(OP_CY,"#,##0,.0M")

 

Return

if(OP_CY > 0, "+"& _2, _2)