How to Create a Project Management Dashboard in Power BI with AI

Building a project management dashboard in Power BI can transform scattered spreadsheets and updates into a single source of truth, but getting started can feel like a project in itself. By using Power BI’s built-in artificial intelligence (AI) features, you can not only build your dashboard faster but also uncover insights you might have missed. This guide is a step-by-step walkthrough of creating a dynamic project management dashboard in Power BI and using its AI tools to do the heavy lifting for you.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Getting Your Project Data Ready

Before you build any visuals, you need solid data. An effective project management dashboard tracks a few key metrics that tell the story of your project's health and progress.

1. Gather Your Essential Project Metrics

Whether you're exporting data from a tool like Jira or Asana or starting with a simple spreadsheet, your dataset should contain these core fields for each task:

• Project Name: The name of the overall project the task belongs to.
• Task Name: A specific description of the individual task.
• Assignee: The person or team responsible for the task.
• Start Date: When the task is scheduled to begin.
• End Date/Due Date: The task's deadline.
• Status: The current state of the task (e.g., Not Started, In Progress, Completed, Blocked).
• Priority: The urgency of the task (e.g., High, Medium, Low).
• Estimated Hours: How long you expected the task to take.
• Actual Hours: The actual time spent on the task.
• Budgeted Cost: The planned cost associated with the task.
• Actual Cost: The real cost incurred to complete the task.

For this walkthrough, we'll assume you have this data structured in an Excel or Google Sheets file. A simple, flat table is often the easiest to work with in Power BI.

2. Connect Your Data Source to Power BI

With your data file ready, the first step is to bring it into Power BI Desktop (a free application from Microsoft).

1. Open a new blank report in Power BI Desktop.
2. On the Home ribbon, click Get Data.
3. Select the appropriate source. For our example, choose Excel Workbook or use the Web connector if your data is in a Google Sheet.
4. Navigate to your file, select it, and click Open.
5. In the Navigator window, check the box next to your table or worksheet. A preview will appear. If it looks clean, click Load. If it looks messy (e.g., extra empty columns, incorrect data types), click Transform Data to open the Power Query Editor for cleaning.

Once loaded, your table's fields will appear in the Data pane on the right-hand side, ready for you to start building.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Building Your Core Dashboard Visuals

Let's lay the foundation with some standard visuals every project manager needs. We'll drag and drop fields from the Data pane onto the report canvas to create these.

Project Overview KPIs

Key Performance Indicators (KPIs) give you an immediate health check. Use the "Card" visual for these.

• Total tasks: Create a Card visual and drag the Task Name field into it. In the Visualizations pane, change its aggregation to Count.
• Budget vs. Actual Cost: Create two Card visuals. One for the Sum of Budgeted Cost and one for the Sum of Actual Cost. Clearly label them so you can see your spending at a glance.
• Overdue Tasks: This is a bit more advanced. You'll need to create a simple DAX measure. On the Home ribbon, click New Measure and enter this formula:

Task Breakdown by Status

Understanding where all your tasks currently stand is critical. A visual breakdown makes bottlenecks immediately obvious.

Use a Donut Chart or Pie Chart for a simple, clear view:

• Drag the Status field to the Legend area.
• Drag the Task Name field to the Values area and set its aggregation to Count.

You can now instantly see the proportion of your tasks that are complete versus in progress or stuck.

Budget Analysis by Project

Is one project responsible for most of your overspending? A bar chart makes this clear.

Use a Clustered Column Chart:

• Drag the Project Name to the X-axis.
• Drag both Budgeted Cost and Actual Cost to the Y-axis.

This side-by-side comparison immediately highlights projects that are over or under budget.

Putting the "AI" in Power BI: Getting Smarter Insights

The core dashboard is built, but here’s where you can save a ton of time and get much deeper insights. Power BI's AI features can interpret the data for you, turning confusing charts into clear answers.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Smart Narratives: Let AI Write Your Project Summaries

Tired of writing the same executive summary in your reports every week? The Smart Narratives visual does it for you by generating a natural language summary of the key takeaways from your dashboard.

To use it:

1. Click on an empty space on your canvas.
2. Select the Smart Narratives visual from the Visualizations pane.
3. Power BI will instantly generate a text box with dynamic, data-driven sentences. For example, it might write something like, "At 34 completed tasks, Project Phoenix accounts for 45% of all completed tasks. This project's actual cost of $22,500 has exceeded its budgeted cost of $20,000."

This text updates automatically whenever the data refreshes or you apply filters. You can copy and paste this directly into an email or presentation.

Q&A Visual: Ask Questions in Plain English

The Q&A (Question & Answer) feature lets you forget about manually filtering charts and allows anyone on your team to get answers just by asking. You don't need to know how to build a visual, you just need to know what you want to ask.

How to use it:

1. Add the Q&A visual from the Visualizations pane.
2. A search box will appear, pre-populated with suggestions to get you started.
3. Start typing your questions as if you were asking a colleague.

Here are some sample project management questions you could ask:

• “Show overdue tasks for David Miller”
• “What is the total actual cost for Project Orion last month?”
• “Sort projects by budget variance”
• “How many tasks are marked with High priority?”

As you type, Power BI generates the perfect visual (a bar chart, a number card, a table) in response. This empowers stakeholders who don’t use Power BI every day to explore the data themselves without a learning curve.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Analyze Feature: Discover What's Driving Your Metrics

This AI feature helps you with root cause analysis. Let's say you see a project that is significantly over budget in your bar chart. Why?

1. In your Project Budget vs. Actuals chart, right-click on the bar for the over-budget project.
2. Select Analyze from the menu, then click Explain the increase (or decrease).

Power BI runs statistical analysis in the background and presents "waterfall" charts showing the factors that contributed most to that change. It might find that most of the budget overage came from tasks assigned to a specific person or tasks that ran overdue, giving you an evidence-based starting point for your investigation.

Tips for an Effective Project Management Dashboard

To make your dashboard truly useful, add these final touches:

• Add Slicers: Slicers are interactive filters. Add slicers for Project Name, Assignee, and Priority so users can easily drill down into the data that’s relevant to them.
• Use Bookmarks: Create different "views" of your dashboard with bookmarks. For example, you could have a "High-Level Summary" view for executives and a "Detailed Task View" for project leads, all in the same report.
• Set Up Scheduled Refresh: If your data source is online (like a work SharePoint or Google Sheet), you can publish the report to Power BI Service (the web version) and schedule an automatic data refresh. This ensures your dashboard is always reflecting the latest information without any manual updates.

Final Thoughts

Building a project management dashboard in Power BI helps you consolidate all your project data into one reliable, visual source. By moving beyond basic charts and embracing Power BI's AI features like Smart Narratives and Q&A, you unlock a smarter, more efficient way to report project status and uncover performance drivers.

While Power BI is incredibly capable, it still requires setup, configuration, and a bit of a learning curve to get right. We built Graphed to remove those hurdles and make deep analysis accessible to anyone. Instead of manually connecting to data and building visuals one by one, with our platform, you simply connect your project tools (like Jira, Asana, or a Google Sheet) and use plain English to ask for what you need - like, "Create a dashboard showing our project timelines, budget versus actuals by assignee, and all tasks with high priority." Our AI builds the live, interactive dashboard instantly, letting you get straight to the insights.