Accurately reflecting Project Progress status in Power BI RRS feed

  • Question

  • I am working with a client who are using Power BI to present project data to stakeholders. Our Power BI developer has produced a range of useful reports including one which displays a list of projects and gantt bars for each project showing their total duration and when they are happening (uncannily like the Project Centre in PWA!).

    Our Power BI person has elected to display status as a darker colour bar, again not dissimilar to how things display in a project centre view. 

    However using the project % complete value tends to distort things - we have some projects that are on track but when viewed in the Power BI report appear to have progress way ahead of where we are in time due to the project having a significant period of time where we are waiting on external factors over which we have no influence and there is nothing actually scheduled to occur in terms of task activity.

    Has anyone got a better way of calculating or representing progress - I was thinking of a comparative, what was planned to have been done by the current date compared to what has happened by that date. Earned Value could have offered some opportunity but we are not generating any cost data in our plans that could drive earned value metrics.

    With good wishes,


    Microsoft Project Evangelist

    Twitter:   LinkedIn:    Web:   

    Friday, February 14, 2020 10:46 AM

All replies

  • Hi Dom,

    I'm not sure I fully understand the issue.  % (duration) complete is a blunt instrument and will have the same issue in PWA as in Power BI.  Are you saying that if something is 50% complete in PWA, the same 50% complete is not displaying the same in Power BI; if so, this is a common issue because you cannot just plonk the Project Percent Complete from PWA into the % Completion field in the Gantt Chart visual.  Same applies for Project Duration, as in PWA this is expressed in minutes and exlcudes non working time, whereas in the PBI Gantt Chart visual I think it is expressed in Days, and includes non working time.  To conclude, ensure your PBI developer is using the right data, and if necessary, converting it correctly, so that you are comparing apples with apples, and not apples with pears.

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

    Friday, February 14, 2020 3:50 PM