PowerBI report to replicate project prioritization RRS feed

  • Question

  • Hi,

    I've recently been asked to look into the driver/priority functionality in PWA. I've created some drivers, prioritised them. Created a new Portfolio analysis and then scored the projects against the driver values. All good so far.

    I want to now show this in PowerBI to add to our suite of reports. I've got all the tables I think I need but I can't find the values for the driver scoring for each project.

    I want to replicate this report:

    Anyone tried something similar?



    Tuesday, February 18, 2020 9:52 AM

All replies

  • Hi, 

    You won't find the driver score for each project, but you will find the priority for each project per Analysis in the PortfolioAnalysisProjects table.

    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Tuesday, February 18, 2020 11:42 PM
  • Thanks Ben - I managed to get that bit from the tables. It's good but I'd love to be able to drill down into each Project ( I can imagine questions will be asked "why is my project low priority")

    The data must exist somewhere...

    Thursday, February 20, 2020 8:50 AM
  • "Why" is the part of the magic, but simply put it delivers little value for money!

    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Thursday, February 20, 2020 9:00 AM