Conditional formatting of percentage measure

[lifeofthenoobie]

Hello, 
I have a calculated group and one of items in Delta of Sum of Sales in percentage like

        DIVIDE(

            SELECTEDMEASURE() - CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR('dim_calendar'[Date])),

            CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR('dim_calendar'[Date])),

            0

        ),

and what I want to achieve is when the percentage is on minus for example -5%, -10% I want this cell in matrix to be highlighted in red (or the font be red if can't make it cell), otherwise if its on plus like 5% or 10% then green

How to achieve this? I tried with rules but its not quite what I expect I guess?

[BeaBF · Accepted solution]

@lifeofthenoobie Hi! Create a measure on the Delta Percentage measure for the conditional formatting, like:

ColorIndicator =
VAR DeltaPercent = [DeltaPercentage]

RETURN
IF(
DeltaPercent < 0, // If percentage change is negative
"Red", // Return "Red" for negative change
"Green" // Return "Green" for positive change
)

then use this measure as field for the conditional formatting.

BBF