Forum Discussion
Table conditional formatting
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!
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])RETURNIf( sel IN SELECTCOLUMNS( topn(2,all('table'), [score],DESC),[specialist]), "Green")
3 Replies
- SamWiseOwlSuper User
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])RETURNIf( sel IN SELECTCOLUMNS( topn(2,all('table'), [score],DESC),[specialist]), "Green")- ajdm2007Helper III
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,
- SamWiseOwlSuper User
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.