Forum Discussion
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...
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:
Best Regards,
Community Support Team _ Eason
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:
Best Regards,
Community Support Team _ Eason