How to Group Project for the Web Tasks in Power BI Reports
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.

- 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, 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.
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.
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.
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.
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.
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.
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.

Ask the Power BI community for project-specific modeling help
Use this if you cannot identify the correct parent-child relationship or the custom DAX measure returns unexpected totals.
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.

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.




