Others

How to Group Project for the Web Tasks in Power BI Reports

Maira MehtabMaira Mehtab Nov 13, 2026 868 views

Question details

The user needs to create a Power BI report that aggregates Project for the Web resource allocation by the parent project task instead of showing individual Level 3 task assignments.

How to Group Project for the Web Tasks in Power BI Reports
Product
Microsoft Power BI and Project for the Web
Device & OS
not provided
Scenario
The user is working with the Project for the Web Power BI template and wants remaining resource allocation to roll up from detailed assignments to the top-level project task.
Observed behavior
The default template shows individual Level 3 task assignments instead of aggregating a resource's remaining allocation under the related Level 1 project task.
Before you start

Before you start, confirm that your Power BI data source includes parent-child task information and resource assignment fields, and open the Power Query editor to review the current table relationships. This will help you decide whether you can create a calculated aggregation or need to reshape the data model.

Solution 1Recommended

Create a custom Power BI measure to aggregate assignments to the parent task

Use this solution when you need the report to roll up Level 3 assignment data to its Level 1 parent task and the default template is showing only detail-level rows.

This approach requires Power BI Desktop and access to the Project for the Web data source. The exact data model and DAX measure depend on your tenant and which Project for the Web tables or Dataverse entities are exposed.

1
Open Power BI Desktop and load the data source

In Power BI Desktop, select Get data, connect to your Project for the Web data source or the Dataverse environment that contains Project for the Web tables, and load the task, assignment, and resource tables into the model.

2
Review table relationships in Model view

Switch to Model view and verify that the assignment table is related to the task table through a Task ID or GUID column. If no relationship exists, create one on the matching task key.

3
Inspect parent task fields

In the task table, identify the parent task ID or hierarchy level field that links Level 3 tasks to the Level 1 project task. Use Power Query to add or rename these columns if they are not clear.

4
Create a DAX measure to sum allocation by parent task

On the Modeling tab, select New measure and create a measure such as Remaining Allocation by Parent Task that uses CALCULATE or SUM over the resource remaining allocation field, filtered or grouped by the parent task ID.

5
Add the parent task and measure to the report

In Report view, add the Level 1 project task field to rows or axis and the new measure to values so the report shows resource allocation grouped under the parent task.

Create a custom Power BI measure to aggregate assignments to the parent task
Power BI modeling may require custom DAX: The exact fields and relationships vary by Power BI template version. If the expected parent-child logic is not available, ask in the Power BI community forum for help with your specific data model.
Free Microsoft Office alternative

WPS Office Is a Free, Lightweight Office Alternative for Project Data Files

WPS Office does not replace Power BI or Project for the Web, but it gives you a free, lightweight Office alternative for opening, editing, and sharing Excel, Word, and PowerPoint files with strong Microsoft Office format compatibility and a familiar interface.

Opens and edits Excel exports from project workflows with Microsoft Office format compatibilityFree and lightweight Office suite for everyday document, spreadsheet, and presentation tasksFamiliar ribbon-style interface makes switching from Microsoft Office easierWorks alongside Power BI by handling source files and exported reports without replacing your reporting tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Project for the Web Power BI template show Level 3 task assignments instead of Level 1 totals?

The default template often exposes data at the assignment grain, so it lists individual lower-level assignments. To group by parent task, you need a custom Power BI data model that maps each task to its parent task and sums the remaining allocation measure at the parent level.

Can WPS Office replace Power BI for Project for the Web reporting?

No. WPS Office is an Office suite for documents, spreadsheets, and presentations. Power BI and Project for the Web are Microsoft services that require their own tools for report authoring and data modeling.

How do I get custom Power BI modeling help for Project for the Web?

Post in the Microsoft Power BI Community with your current table relationships, task ID and parent task ID fields, resource allocation columns, and an example of the Level 1 grouping you expect.

Can WPS Office open Excel exports that I plan to use in Power BI?

Yes. WPS Office supports Excel files, including .xlsx, so you can open, check, and edit exported project data before loading it into Power BI.