Matrix conditional formatting based on comparison to overall average

[Topjacket]

Hello

Sorry if I have missed something but I have tried searching and figuring it out myself but I am struggling with this one.

I have a matrix which shows "Category" in the columns and "Employee Name" in the rows with the value showing as average of "Recorded Time" in minutes. I am trying to format the background so that if a value is -/+5% of the column average then it is coloured Amber and if it is -/+10% then it is Red.

I feel like this should be possible. If anyone has any tips or can point me in the right direction, that would be great.

Thanks in advance

James

[Anonymous · Accepted solution]

Hi @Topjacket 

Color Code = 
VAR AvgOfAll = Calculate(AVERAGE(table[value]),all(table))
Var Avg = Average(table[value])
RETURN SWITCH(TRUE,
              Avg/AvgOfAll >= 10, "Red",
              Avg/AvgOfAll >= 5 , "Amber","")

Use this measure in the conditional formatting.

[Topjacket]

Thanks very much for this.

[Anonymous]

Hello

Look at this subject, I think this is the same for you

https://community.powerbi.com/t5/Desktop/Conditional-formatting-matrix/m-p/2118691

James