Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Project Ranking Algorithm

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 ???
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • augustindelaf's avatar
    augustindelaf
    8 years ago

    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

augustindelaf's avatar
augustindelaf
Impactful Individual
8 years ago

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