Forum Discussion
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 shows is for each sector the sales person has made X number of sales.
In this basic example the average sales for Sector A is 12.3. Meaning Sales Person A is below average for this industry.
In essence based on the different Sectors (in my real data I have 10+) I want to conditional format the sales persons numbers by averages.
I had the idea of calculation average sales per sector as a measure but then I am not sure how to acheive my end goal.
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"
)
1 Reply
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"
)