Using Conditional Formatting based on Column Value

[vidalbra]

Hello All, I new and spent about 45 minutes reading through previous treads not to ask the same question. Unfortunately, I could not find something that helpe me.

I am somewhat versed with Excel, but PBI is not excel ;). So, I am trying to do a conditional formatting to show the below: 

This is in Excel

If the change Y-on-Y is UP = Green, DOWN = Red and UNCHANGED = None.

I tried it on PBI through rules, but was not successful.

This is how the fields look like.

Thank you all in advance - Regards, Vidal

[MFelix · Accepted solution]

Hi @vidalbra .

Do you have a Y-on-Y calculation on your model? You need to create one measure to do that calculation and then use it on the rules where if the Y-on-Y is higer than 0 lower than zero or equal to zero,

No need to place it on the Matrix except on the condittional formatting.

The YoY should be similar to this one:

Value YoY% = 
VAR __PREV_YEAR = CALCULATE( [HeadCount Demand], DATEADD(Calendar[Date], -1, YEAR))
RETURN
	[HeadCount Demand] - __PREV_YEAR