How to Create a Work in Progress Report in Power BI with AI

A Work in Progress (WIP) report shouldn't be a manual spreadsheet you begrudgingly update every Friday. With Power BI, you can create a live, automated dashboard that gives you a clear view of your projects. This guide will walk you through building a WIP report in Power BI and then show you how to use its built-in AI to get even smarter insights with zero extra effort.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is a Work in Progress (WIP) Report?

A Work in Progress (WIP) report is a dashboard that tracks the status of ongoing projects, tasks, and deliverables. Think of it as the mission control for your team’s efforts. It moves beyond a simple 'to-do' list to provide a real-time snapshot of what’s being worked on, who’s working on it, and whether things are on track.

For example, a marketing team might use a WIP report to track every stage of a product launch - from drafting blog posts and designing ad creatives to scheduling social media updates. A development team could use it to monitor progress on new features, showing which tasks are in development, which are in testing, and which are blocked.

The core benefit is visibility. A good WIP report helps you:

• Spot Bottlenecks: Easily see where tasks are piling up or which stage is slowing down the entire project.
• Manage Workloads: Understand team capacity at a glance and reallocate resources before someone gets overloaded.
• Improve Forecasting: Get a more accurate idea of when projects will actually be completed based on the current pace of work.
• Communicate with Stakeholders: Give leaders a clear, high-level view of project health without drowning them in details.

In short, it stops you from having to ask, "So, where are we with that thing?" Instead, the answer is always right there on your screen, updated automatically.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Setting Up Your Data for a WIP Report

Before you can build anything in Power BI, you need well-structured data. Your dashboard is only as good as the information you feed it. Messy, inconsistent data will give you a messy, unreliable report. The good news is, a simple structure is all you need.

You can get this data from dedicated project management tools like Jira, Asana, Trello, or Azure DevOps. But you can start just as easily with a simple Excel or Google Sheets file. The key is to be consistent.

Key Data Points You'll Need

Your source file should be set up like a simple database table, with clear columns for each piece of information. Aim to have at least these fields:

• Task ID: A unique identifier for each task.
• Task Name: A brief, clear description of the work.
• Project Name: The larger project or initiative the task belongs to.
• Assigned To: The name of the person or team responsible.
• Status: The current state of the task (e.g., ‘To Do’, ‘In Progress’, ‘In Review’, ‘Done’). Keep these categories consistent!
• Start Date: When the task began.
• Due Date: The target completion date.
• Completion Date: The actual date the task was finished (you can leave this blank for tasks that aren’t done).

Here’s a simplified example of what your data could look like in a spreadsheet:

A few tips for your data setup:

• Consistency is King: Make sure everyone uses the same terms for statuses. "In Progress" is not the same as "In-Progress." These small differences will be treated as separate categories by Power BI.
• Format Dates Properly: Ensure your date columns are actually formatted as dates in your software, not just text. This is critical for any calculations or time-based analysis.
• Keep it Tidy: One row per task. Don't merge cells or add extra commentary outside the defined columns. The cleaner the source, the less cleanup you have to do later.

Creating Your WIP Report in Power BI: A Step-by-Step Guide

Once your data is ready, it's time to build the actual report in Power BI Desktop. We'll start with the fundamentals to create a useful, functional dashboard.

Step 1: Connect to Your Data

First, you need to pull your data into Power BI.

1. Open Power BI Desktop and go to the Home tab.
2. Click on Get data. You’ll see a list of common sources.
3. If you’re using an Excel file, select Excel workbook. If it’s a Google Sheet, you can use the Web connector and paste the sheet's public URL. Find your file and click Open.
4. The Navigator window will appear. Select the tab or table containing your data and click Transform Data. Always choose 'Transform Data' instead of 'Load' - it's a good habit that takes you directly to the Power Query Editor, where the real "magic" happens.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Clean and Shape Your Data in Power Query

The Power Query Editor is where you clean and prepare your data. Even with a well-organized source file, it’s good practice to double-check everything.

• Check Data Types: Power BI is usually smart about this, but verify that your date columns are set to a Date format and any numerical IDs are set to Whole Number. You can change the data type by clicking the icon next to the column header.
• Handle Blanks: Decide what to do with any empty cells (null values). You might want to replace them with something like "Unassigned" in the 'Assigned To' column using the Replace Values feature.
• Add Custom Columns: This is a great place to create new information from existing data. For instance, you could create an "Overdue" column.

Once you're happy with your data, click Close & Apply on the Home tab to load it into your report.

Step 3: Build Your Visuals

Now for the fun part: creating the charts and tables. Drag fields from the Data pane on the right onto the report canvas.

Here are a few essential visuals for a great WIP report:

• KPI Cards: Use the Card visual to display high-level numbers that matter most. Create three separate cards for:
• Task Status Breakdown (Donut Chart):
• Detailed Task Table (Matrix Visual):

With these elements, you already have a functional report that tells you what’s going on at a glance. But we can make it even smarter.

Level Up Your Report with Power BI’s AI Features

This is where Power BI really stands out. Its built-in AI tools can analyze your data for you and make your report more interactive and insightful without requiring you to be a data scientist.

1. Q&A Visual: Ask Questions in Plain English

The Q&A visual lets anyone - even team members who have never used Power BI - get answers from your data just by typing a question.

• How to add it: Simply double-click on an empty space on your report canvas, and a Q&A input box will appear. You can also select it from the Visualizations pane.
• How to use it: A text box prompts users to "Ask a question about your data."
• Example prompts:

Power BI interprets the question and generates a visual on the fly. This turns your static report into a dynamic conversation, empowering your team to explore the data for themselves.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Smart Narratives: Get Automatic Text Summaries

Staring at charts is helpful, but sometimes you just want the key takeaway in plain text. The Smart Narratives visual does exactly that by generating an automated summary of your dashboard or a specific chart.

• How to add it: Select the Smart Narrative visual from the Visualizations pane. It will automatically analyze the entire report page and generate a text summary.
• What you get: It provides a dynamic summary that updates as you filter the data. For example, it might generate text like: “There are currently 45 total tasks, with a significant concentration in the 'In Progress' status (44%). Last week, this was 35%, marking a noticeable increase." This is perfect for report headlines or executive summaries because it writes the key findings for you.

3. Anomaly Detection: Find the 'Why' Automatically

If you're tracking task completions over time with a line chart, anomaly detection can automatically flag unusual spikes or dips in activity. Better yet, Power BI can try to explain them.

• How to use it: Create a line chart showing the count of completed tasks by date. In the Analytics pane for that visual, turn on Find Anomalies. Power BI will highlight any points that deviate from the expected pattern.
• Explain the anomaly: Once an anomaly is detected, you can click on it and ask Power BI to analyze what might have caused it. It will check your other data fields (like project or person) to find possible drivers for the change, such as “The spike was largely driven by completions on the ‘Q4 Marketing Campaign’ project.” This saves you hours of digging through data to figure out what happened.

Final Thoughts

Building an automated WIP report in Power BI transforms your project tracking from a manual chore into a source of automated, real-time insight. By adding AI features like Q&A and Smart Narratives, you can make the data accessible to your entire team, allowing them to find answers and spot trends without needing technical assistance.

At Graphed, we’re obsessed with making data this simple. If you like the idea of asking questions in plain English but want to do it across all your data sources - like Google Analytics, Salesforce, and a dozen others - without the steep learning curve of a traditional BI tool, you'll love what we're building. We let you connect your apps and then simply describe the dashboard you want to see, and our AI builds it in seconds. Feel free to check out Graphed for an even faster way to get answers from your business data.