How to Create a Project Portfolio Dashboard in Power BI

Juggling multiple projects feels less like project management and more like spinning plates. You're constantly switching between spreadsheets, project plans, and status updates, trying to piece together a clear picture of what's on track, what's falling behind, and who's completely overloaded. Building a project portfolio dashboard in Power BI brings all of that crucial information into one dynamic, visual command center. This tutorial will walk you through creating one from scratch, covering everything from preparing your data to building the essential charts that will finally give you that bird's-eye view.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why a Project Portfolio Dashboard is a Game-Changer

Before we jump into the "how," let's quickly touch on the "why." A centralized dashboard isn't just a pretty report, it’s a powerful tool for making better decisions. When done right, it helps you:

• See the big picture instantly. Get a high-level view of every project's health, budget, and timeline without digging through endless files.
• Spot bottlenecks and risks early. Easily identify projects that are over budget, behind schedule, or flagged as high-risk before they become major problems.
• Manage resources effectively. See who is assigned to what, identify overloaded team members, and reallocate work to keep things balanced and moving forward.
• Communicate with stakeholders. Stop sending ten different status reports. A single, shared dashboard gives everyone the real-time information they need in a format they can easily understand.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Project Data in Order

Power BI is powerful, but it's not a mind reader. Your dashboard will only be as good as the data you feed it. Garbage in, garbage out. The goal is to have a single, clean data source that can power all of your visuals. This usually lives in an Excel or Google Sheets file, a SharePoint list, or a dedicated project management tool.

For this tutorial, let's assume we're starting with a simple spreadsheet. Structure your data in a flat table format, with clear columns and one row per task or major project milestone. Here are the essential columns you'll want to include:

• ProjectID: A unique identifier for each project.
• ProjectName: The name of the project.
• TaskName: The specific task or milestone.
• ProjectOwner: The main lead or manager for the project.
• AssignedTo: The person or team responsible for the task.
• StartDate: The planned start date for the task.
• EndDate: The planned end date for the task.
• ActualEndDate: The date the task was actually completed (leave blank if not done).
• Status: The current status (e.g., Not Started, In Progress, Completed, Delayed).
• PercentComplete: The task completion percentage (from 0 to 1).
• BudgetedHours: The hours allocated for the project or task.
• ActualHours: The hours spent to date.
• BudgetedCost: The total budget allocated to the project.
• ActualCost: The spending to date.
• RiskLevel: A simple risk rating (e.g., Low, Medium, High).

Pro Tip: Consistency is everything. Make sure your status names, project names, and date formats are consistent across the entire file. This will save you a massive headache later.

Step 2: Connect Your Data to Power BI

With your data prepped, it's time to pull it into Power BI Desktop.

1. Open Power BI Desktop.
2. On the Home ribbon, click Get Data.
3. Select the correct source. If your data is in Excel, choose Excel Workbook. If it’s in Google Sheets, choose Web and paste the shareable link.
4. Navigate to your file and select the worksheet containing your project data.
5. A preview window will appear. If your data looks clean, you can click Load. If you need to make changes (like renaming columns or changing data types), click Transform Data. This opens the Power Query Editor, where you can clean up your data before loading it into your model.

For now, let’s assume your data is clean and ready. Once loaded, you’ll see your table and its fields appear in the Fields pane on the right side of the screen.

Step 3: Build the Core Visuals for Your Dashboard

This is where your dashboard starts to come to life. We’ll build a few key visuals that are essential for any project portfolio view. Drag and drop visuals from the Visualizations pane onto your blank canvas and then drag fields from the Fields pane into the visual's settings.

Visual 1: Project Timeline (Gantt Chart)

You can't manage a project portfolio without seeing how all the timelines overlap. While Power BI doesn't have a native Gantt chart, there are excellent free ones available in the custom visuals marketplace.

1. In the Visualizations pane, click the three dots (...) and select Get more visuals.
2. Search for "Gantt" and add a popular option like the one from MAQ Software.
3. Add the Gantt chart visual to your canvas.
4. Drag your fields into the visual's settings wells:

Instantly, you have a visual timeline of all tasks across all projects.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Visual 2: Budget vs. Actual Cost

One of the most important questions is, "Are we on budget?" A clustered column chart is a great way to show this.

1. Add a Clustered column chart visual to your report.
2. Drag the fields into the appropriate wells:

This simple chart clearly shows which projects are approaching or exceeding their budgets. You can take this a step further by creating a calculated "Variance" measure using DAX, but this gives you a great starting point.

Visual 3: Project Status Overview

A donut chart provides a quick, color-coded view of where projects currently stand.

1. Select a Donut chart from the Visualizations pane.
2. Drag your fields:

Now you can see at a glance how many projects are "In Progress" versus "Completed" or "Delayed."

Visual 4: Key Performance Indicator (KPI) Cards

Sometimes you just need the raw numbers at the top. Cards are perfect for displaying high-level totals.

1. Select the Card visual.
2. Drag a single field you want to display, like BudgetedCost. Under the field settings, make sure it’s summarizing as a Sum.
3. Repeat this process to create separate cards for:

Place these cards prominently at the top of your dashboard for an executive summary.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Make It Interactive with Slicers

This is what elevates your report from a static image to a dynamic dashboard. Slicers act as filters for your entire report page, allowing you or your stakeholders to drill down into the data.

1. Find the Slicer visual in the Visualizations pane and add it to your canvas.
2. Drag a field you want to filter by, such as ProjectOwner, into the Field well. Now you have a simple list of project owners.
3. Click on a name in the slicer, and watch your entire dashboard instantly update to show data only for that person's projects.
4. Create additional slicers for other key dimensions, like:

With these filters, you can answer questions like "Show me all the 'High Risk' projects for Jane Doe that are currently 'In Progress'" with just a few clicks.

Best Practices for a Great Dashboard

You have the data and the visuals. But what separates a decent dashboard from a great one often comes down to design and usability.

• Keep It Simple: Don't try to cram every possible metric onto one page. Focus on the most important information needed to make decisions. The cleaner the layout, the easier it is to understand.
• Use Color Thoughtfully: Use colors to signal meaning. For example, use red in your budget charts for projects that are over budget or in your status charts for projects that are delayed.
• Tell a Story: Arrange your visuals in a logical order. Start with a high-level overview at the top (your KPI cards) and allow users to drill down into more detail as they move down the page (your charts and tables).
• Label Everything Clearly: Use clear, concise titles for your charts and tables. No one should have to guess what they are looking at.

Final Thoughts

You’ve started with a jumble of project data and turned it into a clear, interactive, and insightful dashboard. By organizing your data, connecting it to Power BI, and building a few key visuals, you've created a single source of truth that empowers you to manage resources, track budgets, and proactively address risks across your entire project portfolio.

If connecting data sources, cleaning data in Power Query, and building visuals in Power BI feels like a project in itself, tools are emerging that streamline this whole process. When designing Graphed , we focused on eliminating that friction. We allow you to connect your data sources in a few clicks and then use simple, natural language to get the reports you need. Simply asking, "show me a bar chart of actual vs budgeted cost by project" instantly creates the visual, helping you get to insights in seconds, not hours.