Maintenance KPI – Planned Vs Actual Work Order Hours (Planner Accuracy) – Power BI Dashboard

Learn how to use Power BI to create a Planned vs Actual Work Order Maintenance KPI.

In this video I'll take you step-by-step through the process of setting up the calculated columns and measures required to created a planned vs actual work order hours KPI.

Planned vs actual hours (Planner accuracy) is a maintenance KPI that compares the hour originally planned on a work order against the final total hours booked to a work order. However this approach could be used for cost too. It could also be used in project management or any ticketing system that has the concept of planned vs actual analysis.

The approach I cover also let you set different planned vs actual tolerance levels for work orders with different planned hours. For example you might want to set a higher planned vs actual tolerance level for work order with a lower number of hours.

Once I've set-up the calculations I'll then take you through the process I took when creating a planned vs actual hour planning accuracy dashboard.

Tip: This is a longer video so why not try increasing the playback speed to save time. Research has shown that this can speed up your learning! You'd be surprised how well it works!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Recent Posts

About the author 

Jason Davidson

Jason Davidson is the founder of He is a maintenance and reliability engineer who uses Power BI every day to create dashboards that help him and others make better decisions. In his spare time, he likes running and has recently got into photography. He also loves spending time hanging out and larking about with his two daughters.

FREE Power BI Quick Start Course

Learn how to build a Power BI dashboard in under 90 minutes.