Maintenance KPI – Percentage of Proactive and Reactive Work Hours Completed

In this video, I'll explain how to use Power BI to calculate the percentage of proactive work completed in a period.

Once I've covered how to create the calculation for the percentage of proactive maintenance hours I'll then take you through how I created a dashboard to display this KPI.

I'll talk you step-by-step through my thinking process in deciding how I laid out the dashboard page and the formatting I used for each visual and why.

This maintenance KPI is important because it helps the maintenance management team understand the balance of activity the maintenance team is working on.

If they are working on proactive work activities then they are focusing on activities designed to prevent equipment from failing or detect impending failures early. This means they can do something about these issues before they become severe and result in an impact on the business.

If the balance is more toward reactive activity then they are busy fixing failures rather than proactively working to prevent them from happening in the first place!

{"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.