A portfolio dashboard has one job: let a leader look at every project at once and know, in seconds, which ones need attention. Most fail at that job. They cram in thirty metrics, refresh once a month by hand, and end up as a slide nobody trusts. The dashboards that work are ruthless about what they leave off. This guide covers what actually belongs on a project portfolio dashboard, shows an example layout, and walks through building one in Excel or Power BI without turning it into a second full-time job.
Key takeaways
- A project portfolio dashboard is one view of all active projects, showing status, budget, schedule, risk, and resource load so leaders can decide what needs attention without reading every status report.
- Start from the decisions the dashboard supports, not the metrics you can collect. If a number will not change a decision, leave it off.
- Five to seven columns cover most portfolios: project, owner, RAG status, percent complete, budget variance, key risk, and next milestone.
- Lead with the portfolio-level rollup (how many projects are red, total spend vs budget), then let the reader drill into the project list.
- Build it in Excel for a portfolio under about a dozen projects; move to Power BI or a PPM tool when manual updates start eating half a day.
What is a project portfolio dashboard?
A project portfolio dashboard is a single visual view of every active project in a portfolio, showing each project's status, schedule, budget, risk, and resource demand side by side. Its purpose is not to report on any one project in detail; it is to let a PMO or leadership team scan the whole portfolio and see immediately which projects are on track, which are slipping, and which need a decision this week.
The difference between a portfolio dashboard and a project dashboard matters. A project dashboard drills deep into one project's tasks, milestones, and burndown. A portfolio dashboard stays shallow on purpose: one row per project, a handful of columns, and a rollup at the top. You are trading depth for breadth, because the person reading it is deciding where to spend attention across twenty projects, not managing one.
What should a project portfolio dashboard include?
Start from the decisions the dashboard has to support, then work backward to the metrics. A useful portfolio dashboard answers four questions: Are we on track overall? Which projects are in trouble? Are we within budget? Do we have the people to deliver what is left? Everything on the dashboard should serve one of those questions, and anything that does not gets cut.
For most portfolios, the core project table needs five to seven columns. Here is a practical set with what each column is for.
| Element | What it shows | Why it earns a place |
|---|---|---|
| Project name and owner | What it is and who is accountable | Every red status needs a name to chase, not a project code |
| RAG status | Red, amber, or green health at a glance | The single most-scanned field; drives where attention goes |
| Percent complete | Progress against plan | A project at 20 percent complete and 80 percent through its timeline is a problem the RAG may not yet show |
| Budget vs actual | Committed and actual spend against the approved number | The earliest reliable signal of trouble, often before the schedule slips |
| Key risk or blocker | The one issue most likely to derail it | Turns a red status into something a leader can act on |
| Next milestone and date | The next commitment and when it is due | Makes slippage visible before it becomes a surprise |
| Resource load | Whether the project is adequately staffed | Explains most schedule variances the other columns cannot |
Above that table sits the portfolio rollup: total active projects, the count that are red or amber, total budget vs total spend, and overall resource utilization. That rollup is what a busy executive reads first. The project table is the drill-down for when a number in the rollup looks wrong. Keep the whole thing to one screen. If a reader has to scroll to find the red projects, the dashboard has already failed its five-second test.
Resist the urge to add a column for every stakeholder request. The fastest way to kill a dashboard is to make it comprehensive. A dashboard that shows the seven things that drive decisions beats one that shows forty things nobody reads, and it beats it every review.
The metrics that belong on a portfolio dashboard
Pick three to five headline metrics for the rollup and stop there. The metrics that consistently earn their place track health, money, and delivery. Below are the ones worth showing, and roughly how to read each.
| Metric | What it tells you | Watch for |
|---|---|---|
| RAG status distribution | How many projects are red, amber, green | A rising amber count is the early warning; do not wait for red |
| Budget variance | Total actual and committed spend vs approved budget | Committed cost, not just paid invoices, or you see overruns too late |
| Schedule variance | Whether projects are ahead of or behind plan | Percent complete far below percent of timeline elapsed |
| Resource utilization | How loaded key roles and teams are | Sustained utilization over roughly 85 percent means no slack for slippage |
| Benefit or strategic alignment | Whether the portfolio is funding the right work | Too much spend on low-alignment projects |
If your organization runs formal earned value, the schedule performance index (SPI) and cost performance index (CPI) belong in the rollup too, since one number each captures schedule and cost health. Most portfolios do not need that rigor, and a plain budget-variance column plus a percent-complete-vs-timeline check tells the same story with far less bookkeeping. Match the metric to the maturity you actually have. These headline numbers are the visible tip of a wider set; the full measurement layer sits in your portfolio KPIs and metrics.
Example project portfolio dashboard layout
A clean layout has three bands stacked top to bottom. The top band is the rollup: four or five big numbers, or simple tiles, that give the whole portfolio in one glance ("14 active projects, 3 red, spend 92% of budget, key roles at 88% utilization"). The middle band is the project table, one row per project, sorted so the red and amber projects float to the top. The bottom band is optional context: a spend-by-quarter bar, a projects-by-strategic-theme split, or an upcoming-milestones strip.
Color does most of the work. Use red, amber, and green consistently and sparingly, and reserve strong color for the status column so the eye lands there first. Everything else stays neutral. A dashboard where six columns are color-coded has no signal left, because when everything is highlighted, nothing is. One well-placed red cell in an otherwise calm table is worth more than a rainbow.
Sort matters more than people expect. If the table is sorted alphabetically, the reader has to scan every row to find trouble. Sort by status, worst first, and the projects that need a decision are always in the top three rows. The dashboard should put the problems in front of the reader, not make the reader hunt for them.
How to build a project portfolio dashboard in Excel
For a portfolio under roughly a dozen projects, Excel or Google Sheets is genuinely the right tool. Build it in three tabs. The first is a data tab: one row per project with columns for name, owner, status, percent complete, budget, actual spend, next milestone, and a key-risk note. Everyone updates this tab, and only this tab. The second is the dashboard tab, which reads from the data tab and never gets typed into directly. The third is a lookup tab for the RAG rules and any drop-down lists, so status is picked from a list rather than typed freehand.
On the dashboard tab, use conditional formatting to color the status cells automatically from the data, a few COUNTIF or SUMIF formulas to build the rollup tiles (count of red projects, total budget vs total actual), and a sort on the project table so red rises to the top. Keep formulas simple and visible; a dashboard that only one person understands is a dashboard that breaks the week they are on vacation. If you already keep a resource model, the utilization figure can come straight from your capacity planning template rather than being maintained twice.
How to build one in Power BI or a PPM tool
Move beyond Excel when one of three things happens: manual updates start eating half a day each cycle, the single file forks into competing versions, or you need the dashboard to refresh itself from the systems where the data already lives. Power BI connects to your project, finance, and resource sources and rebuilds the same three bands, rollup, project table, context charts, on a schedule, so the numbers are current without anyone retyping them. That automatic refresh is the real upgrade; the visuals are not much better than a well-built spreadsheet, but the trust that comes from live data is.
A dedicated PPM tool goes further, generating the portfolio dashboard from the same database that runs intake, prioritization, and capacity, so status, spend, and resource load are never out of sync. The tradeoff is cost and setup, and it is only worth it once the portfolio is large enough that keeping several spreadsheets aligned has become the bottleneck. We cover when to make that jump in our guide to PPM software and tools. Whatever tool you land on, the dashboard is only half the job; how you present and narrate it in the review is covered in PMO reporting and portfolio dashboards.
Frequently asked questions
What is a project portfolio dashboard?
A project portfolio dashboard is a single view of every active project in a portfolio, showing each project's status, schedule, budget, risk, and resource load side by side. Its purpose is to let leaders scan the whole portfolio and see which projects are on track and which need a decision, without reading a separate status report for each one. It stays shallow on every project so it can stay broad across all of them.
What should a project portfolio dashboard include?
Include a portfolio rollup at the top (active project count, how many are red or amber, total budget vs spend, resource utilization) and a project table below it with five to seven columns: project and owner, RAG status, percent complete, budget vs actual, key risk, and next milestone. Start from the decisions the dashboard supports and leave off any metric that will not change a decision.
What metrics should be on a portfolio dashboard?
Pick three to five headline metrics: RAG status distribution, budget variance against approved spend, schedule variance or percent complete versus timeline elapsed, and resource utilization of key roles. Portfolios running earned value can add schedule performance index (SPI) and cost performance index (CPI). More than five headline metrics dilutes the signal, so leave off anything that does not drive a decision.
How do you create a project portfolio dashboard in Excel?
Build three tabs: a data tab with one row per project (name, owner, status, percent complete, budget, actual, next milestone, key risk), a dashboard tab that reads from it, and a lookup tab for RAG rules and drop-downs. Use conditional formatting to color status cells automatically, COUNTIF and SUMIF formulas for the rollup tiles, and sort the project table by status so red projects appear first. Never type directly into the dashboard tab.
What is the difference between a project dashboard and a portfolio dashboard?
A project dashboard drills deep into one project's tasks, milestones, and progress, and is used by the team delivering it. A portfolio dashboard stays shallow on every project, one row each, so leaders can compare all active projects and decide where to spend attention. The portfolio view trades depth for breadth, because its reader is allocating focus across many projects rather than managing one.