cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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.

1 ACCEPTED SOLUTION
Super User

@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"
)

Super User

@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"
)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.