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_r...
  • SamWiseOwl's avatar
    1 year ago

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