Construction Project Dashboard Template — Earned Value, Float & RFI Control (Power BI)

Your team already pays $14 per user/month for Power BI Pro (Microsoft list price effective 1 April 2025) and it still opens on an empty canvas. Point this at your cost report, your P6/MS Project export and your RFI register, hit Refresh, and read CPI, SPI, Forecast at Completion, worst float and overdue RFIs on three pages.

Measures included (DAX) (8)

Columns your data must have (28)

Cost Ledger

Header row: Project Name,Cost Code,Work Package,Period End Date,Original Budget,Approved Change Orders,Committed Cost,Actual Cost to Date,Earned Value,Planned Value

Schedule Tasks

Header row: Project Name,Activity ID,Activity Name,Baseline Finish,Forecast Finish,Total Float Days,Finish Variance Days,Percent Complete,Is Critical

Open Items

Header row: Project Name,Item Type,Reference,Date Raised,Response Due Date,Days Open,Is Open,Is Overdue,Cost Impact

Report pages (3)

• Cost Control — Earned Value — Visuals (6): Cost Performance Index, Schedule Performance Index, Forecast at Completion, Uncommitted Budget by Cost Code, Forecast at Completion by Period End Date, Project Name
• Programme — Float & Slippage — Visuals (6): Average Finish Variance Days, Worst Float Days, Average Finish Variance Days by Activity Name, Total Float Days by Activity Name, Slippage Register — Baseline Finish vs Forecast Finish, Project Name
• RFIs, Submittals & Cost Impact — Visuals (6): Overdue Items, Exposure from Open Items, Overdue Items by Item Type, Exposure from Open Items by Item Type, Open Register — Reference, Raised, Response Due, Project Name