Forum Discussion
Solved
Row by Row Conditional formatting
I have a table showing similar information to this: Sales Person A Sales Person B Sales Person C Sector A 10 12 15 Sector B 11 13 14 Sector C 12 15 10 What this s...
andrewb95 , assume you have measure sales, create a measure like this, and use that in conditional formatting using the field value option
Measure =
var _sales = [sales]
var _avg = calculate(averageX(Values(Table[sales Person]), [sales]), filter(allselected(Table), Table[Sector] = max(Table[Sector])))
return
Switch( True() ,
_sales < _avg , "red",
"green"
)
andrewb95 , assume you have measure sales, create a measure like this, and use that in conditional formatting using the field value option
Measure =
var _sales = [sales]
var _avg = calculate(averageX(Values(Table[sales Person]), [sales]), filter(allselected(Table), Table[Sector] = max(Table[Sector])))
return
Switch( True() ,
_sales < _avg , "red",
"green"
)