Forum Discussion

ajdm2007's avatar
ajdm2007
Helper III
1 year ago
Solved

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])
    RETURN
    If( sel  IN SELECTCOLUMNS( topn(2,all('table'), [score],DESC),[specialist]), "Green")

3 Replies

  • 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's avatar
      ajdm2007
      Helper 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,

       

      • SamWiseOwl's avatar
        SamWiseOwl
        Super 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.