Power BI Multi-Project Status Report Dashboard (PBIX + Excel Bundle)

This report provides a structured way to view multiple projects in one Power BI file. It includes pages for project summaries, financials, risks, issues and timelines, with a Project Name slicer that lets you switch between projects quickly.

What you get in the download zip:

• The Multi-Project Status Report .pbix file - A fully interactive Power BI report pre-loaded with sample data. We swapped the traditional static scorecard for a dynamic Project Name Slicer, allowing stakeholders to filter metrics instantly. It also includes new Department tracking fields (replacing the old effort status layout) to easily slice data by business unit.
• The Excel Data Schema - An organised spreadsheet sample data designed for infinite horizontal growth. The Power Query backend is engineered to handle hundreds of projects and tasks dynamically. The file comes pre-loaded with sample data for 3 distinct projects so you can see the initial visual mechanics, but scaling to dozens or hundreds of projects and their tasks requires zero extra Power BI coding - you simply append your own project tables into the existing 'Tasks' query within Power Query and hit refresh. This underlying data model can also be extended to your chosen project data source and is not limited to Excel.
• Free lifetime updates - if the file is improved or updated in the future, you’ll receive the new version at no extra cost.
  

Compatibility:

• Built entirely in Power BI Desktop using native visuals. No user licenses required.
• Works directly out of the box with the included Excel sample data.
• The data layer is completely decoupled, meaning if required, your internal analysts can easily remap the fields to enterprise PPM systems or cloud databases later.

Power BI Desktop is required to open and use this report. No Premium or Fabric licences are needed unless you choose to publish it to the Power BI Service.

Quick Start Instructions

1. Download: Save and extract the .zip package containing the .pbix file and the Excel data source.
2. Repoint Data: Open the report in Power BI Desktop. Select 'Transform Data' > 'Data Source Settings' and point the source to the included Excel file.
3. Refresh: The visuals will update instantly with the starter data.

When ready, replace the sample Excel file with your own project data or connect to your preferred data source. Refresh the report to view your projects in the multi project layout. You can adjust labels, colours and layout to match your organisation’s reporting style.

Want a completely hands-off setup?

If you or your delivery teams don't have the time to configure data models, you can pair this template with our Custom Column Mapping Service. Simply email us your plain text column headers. Our team handles the underlying Power Query automation behind the scenes and delivers a pre-linked, custom-mapped .pbix file straight to your inbox within two business days. No company data required.

This report helps teams manage multiple projects in a consistent and professional format. It reduces manual reporting effort and supports clearer communication with stakeholders.

Instead of paying a contract data engineer which may cost over £1,000 to build a custom Power BI model from scratch or waiting in the queue for internal BI support, you can download this compiled PBIX file and get your reporting sorted immediately.

This report has been created by Freedom Solutions and is not affiliated with or endorsed by Microsoft. Microsoft and all Microsoft product names including Power BI, Excel, Power Apps, Power Automate, SharePoint, Teams and Office are trademarks of Microsoft Corporation.

This report is provided for individual use only. Redistribution, resale or public sharing including modified versions is not permitted without written permission.

This report is provided as a PBIX file and does not include customisation or support for specific data models. You may need to adjust field names or data types to match your own project information. The sample Excel file is for demonstration only and should be replaced with your own data before using the report for formal updates.

This report is provided for informational and reporting purposes only. Freedom Solutions is not responsible for any decisions, actions, financial loss or operational impact resulting from how this report or its outputs are used.

By downloading the files, you accept Freedom Solutions Terms of Service.

© 2026 Freedom Solutions. All rights reserved.