Forum Discussion
Helper IMatrix conditional formatting based on comparison to overall average
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
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.
3 Replies
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
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.
TopjacketThanks very much for this.