Project Ranking Algorithm

[Anonymous]

hi ,
i have projects and there revenue,billed utilization ,contribution, headcount ,attrition,cost i want to rank projects by some algoritm you have any advice ???

[augustindelaf · Accepted solution]

Hi @Anonymous

You May create dedicated score to each KPI, by using conditional columns in the query Editor, with simple "If Statements".

(see screenshot)

When you have all your scores for each KPI, you may create an Overall Score.

watch my "Ranking" dashboard here, does it look like something you would like to have ? :

https://community.powerbi.com/t5/Data-Stories-Gallery/Business-Schools-Dashboard-France/m-p/187496

I can show you how to do that step by  step, it is quite easy and short.

Best Regards,

Augustin