Table conditional formatting

[ajdm2007]

Hello everyone, 

I’ve developed a dashboard to evaluate the performance of my team of specialists.

As you can see, the "score" column shows the result of the following metric:

agent_ranking = 
VAR TotalT1 = CALCULATE([total_tickets_solved_by_complexity_tier_1])
VAR TotalT2 = CALCULATE([total_tickets_solved_by_complexity_tier_2])
VAR TotalT3 = CALCULATE([total_tickets_solved_by_complexity_tier_3])
VAR TotalNT = CALCULATE([total_tickets_without_category])
VAR TotalNC = CALCULATE([total_tickets_no_solved])
VAR TotalInSLA = CALCULATE([sla_complaint])
VAR TotalNOSLA = CALCULATE([outside_sla])
VAR TSDR = CALCULATE([sdr])
VAR ART = CALCULATE([avg_solution_time])
VAR AREPLYT = CALCULATE([avg_reply_time])
VAR AFRES = CALCULATE([avg_full_res_time])
RETURN
    (VALUE(TotalT1) * 0.07)
    + (VALUE(TotalT2) * 0.09)
	+ (VALUE(TotalT3) * 0.20)
    + (VALUE(TotalNT) * 0.01)    
	+ (VALUE(TotalNC) * 0.04)
    + (VALUE(TotalInSLA) * 0.12)
    + (VALUE(TotalNOSLA)*0.03)
    + (VALUE(TSDR)*0.08)
    + (VALUE(ART)*0.14)
    + (VALUE(AREPLYT)*0.12)
    + (VALUE(AFRES)*0.10)

Now I need help with two things:
1. Applying conditional formatting to highlight the two specialists with the highest scores.
2. Bolding the column with the specialists' names.

Could you assist me with this?

Thank you guys!

[SamWiseOwl · Accepted solution]

Hi @ajdm2007 

Create a measure that performs the above calculation and returns a colour for the highlighted value.

Format top 2 =

var sel = SELECTEDVALUE('table'[specialist])

RETURN

If( sel  IN SELECTCOLUMNS( topn(2,all('table'), [score],DESC),[specialist]), "Green")

[ajdm2007]

Hello @SamWiseOwl 

I figure it out by my self, but I have given you the solution mark.

I'm missing the answer for the second question, how can I set bold the Specialist column?

Thank you so much,

[SamWiseOwl]

Hi @ajdm2007 

I'm not 100% sure what you would like to do.

If you mean the header without conditional formatting then you can do it under specific column by choosing header:

If you want to do it via conditional formatting that currently isn't avilable.

There is a custom visual by Inforiver that can do this.