Conditional Formatting Percentage Variance

[newgirl]

Hi!

I've tried several combinations but I can't get the conditional formatting right.

I have a card in my report that has the measure to compute for the % variance of the volume from previous month. I'm using the measure 'VolumeDiffvsPM' in my card.

VolumeDiffvsPM = ([Volume]/[Volume_PM])-1

Volume = SUM('CR tbl_phrawsales'[Actually billed amount])

Volume_PM = CALCULATE([Volume],DATEADD('Calendar'[Date],-1,MONTH))

Simply put, I want the % values to be green if volume increased and red if it decreased. This is my current set-up and I can't produce the output of conditional formatting that I want. 

Hope you can help me!

[amitchandak · Accepted solution]

@newgirl , You have shown measure as VolumeDiffvsPM  , but you are using VolumeDiffvsPY in conditional formatting

[newgirl]

Ooh so that's why! It's weird because I didn't change the dropdown in 'Based on Field' but after checking my file when I saw your reply, it looks like when I use the format painter, it also copies the choice from the 'Based on Field' from the previous card.

Nevertheless, thank you!