Ranking and showing top 3 in a clustered column chart

[Anonymous]

So I have this data where we are measuring areas of improvement. Each measured skill, say for example "Empathy" and all the others(there's about 25+ measured skills). has it's own answers such as Yes, No, and N/A. We're trying to identify the acount of measured "No" responses. It's why you see a lot of "Count of Skill" measurements. I calculated the measured No resposnes and created No's for each measured skill. I put those into a clustered column chart and I'm only wanting to identify the top 3 for each day.

Can anyone provide some guidance? I've been doing research all weekend and found a lot of posts. I've tried creating some "Sum" and using rankx with the guidance of the posts I've been finding, but I'm just not getting anywhere.

The outcome I'm trying to accomplish is for each day, show the top 3 areas of improvement(which measured skill received the most No's for that day). Then below that will be another clustered chart that identities the top 3 trends being used for each measured skill(the solution trend measurement).

So take for example the count of empathy, I used the following:

Count of Empathy = CALCULATE(Count('Total Voice Audits'[Empathy]),'Total Voice Audits'[Empathy]="No")

For the count of solution trend, since it has multiple trends we have to identify, I did a search for a key phrase(one of the trends).

Count of Solution Trending - Skips required steps = COUNTROWS(FILTER('Total Voice Audits',CONTAINSSTRING('Total Voice Audits'[Solution Trending],"Skips required steps from the selected KA or approved materials (excludes probing questions)")))

I apologize for the newbish question, but any guidance and help is appreciated.

[lbendlin · Accepted solution]

The simplest approach would be to use a Ribbon Chart for a graphical solution.

You shouldn't need individual measures for this - it's a lot of maintenance effort.