Forum Discussion

PraveenMRRP's avatar
PraveenMRRP
Frequent Visitor
2 years ago

Conditional Formatting on Matrix - Comparing Values per Previous Quarters Dynamically

Hi all,   Hoping to get some assistance - I have seen many posts that have similar issues, however, unable to get this to work myself. I require that every quarter should compare with previo...
Need Help
vicky_'s avatar
vicky_
Super User
2 years ago

I first created a measure to calculate the change % - 

Change (%) = 
var prevAmt = CALCULATE(SUM('Table (2)'[Amt]), PREVIOUSQUARTER('Table (2)'[Date]))
var currentAmt = SUM('Table (2)'[Amt])
var change = (currentAmt - prevAmt) / currentAmt
return IF(ISBLANK(prevAmt), BLANK(), change)

Then go to Format Visual > Cell Elements > Font Colour > fx

and use the following settings:
Format style = Rules
What field should we base this on = Change (%) Note: this is the measure I created earlier

Rules = If value >= 0 percent and < 0.1 number then colour.