Sparkrock 365 logo
Sparkrock 365 logo
All Rights Reserved | Sparkrock © 2025

Search Results for

    Project Performance to Budget (Power BI Report)

    APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).

    The Project Performance to Budget report can help you keep your projects under budget. For each project, it shows the budgeted total cost and the project's actual cost.

    Screenshot of the Project Performance to Budget Power BI Report

    Use the report

    Project managers want a clear view of projects to ensure they're on budget. The report lets them compare the budget and actual costs of each project.

    Key Performance Indicators (KPIs)

    The Project Performance to Budget report includes the following KPIs:

    • Actual (Total Cost)
    • Budget (Total Price)
    • Total Cost Variance to Budget
    • Total Cost Variance to Budget %
    • % Complete
    • % Invoiced

    Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

    Tip

    Tip:
    You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

    Data used in the report

    The report uses data from the following tables in Business Central:

    • Project
    • Project Ledger Entries
    • Project Planning Line

    Try the report

    Try the report here: Project Performance to Budget

    Tip

    Tip:
    If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.

    See also

    Track your business KPIs with Power BI metrics
    Power BI Projects app
    Built-in Projects reports
    Project management analytics overview
    Project management overview

    All Rights Reserved | Sparkrock © 2025