Forum Discussion
filtering a skill matrix
I have the follwoing issue and would be happy about some advice. I am building up a skill matrix for people and would like to have a nice representation of what is the average skill per country p...
Assuming your skills are numeric (if not, you can use Greg_Deckler method to create a new calculated column) and the range is from 1 to 5 you can make a star rating with the measure
Avg Skill 1 = REPT(UNICHAR(9733), ROUND(AVERAGE(Skillz[skillz 1]),0)) & REPT(UNICHAR(9734), 5-ROUND(AVERAGE(Skillz[skillz 1]),0))
For max use function MAX instead of AVERAGE.
If the range goes say to 4 replace the 5 in the measure with 4.
You result could look like: