Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

HELP! I need to format and group P4W Projects, Summary Tasks and Tasks

I'm having a problem with sorting and grouping summary tasks and task.  I have multiple projects (P4W) and the download MS P4W dashboard.  I just want a simple way to format the visual in the same way the project does (see below) using expandable hierarchy.   

I can't find a column in the Project Task Table that I can sort by.   Is there a way to create a hierarchy that look similar to projects. 

The subtasks (Projects and Annual Activates) in P4W are not grouped and listed as tasks in the Power BI visual.  

 

PW4

fm114fm_2-1660325859634.png

 

 

Power BI

fm114fm_3-1660325976151.png

 

1 ACCEPTED SOLUTION
KratosBI
Regular Visitor

Good Morning fm114fm,

 

Great question, 

 

To create the hierarchy, you need to shape your data so you have one column for your parent items (Projects, Annual Activities) and one column for all of the child tasks (Medium Impact Complaint, Maintain GO GOP TO and TP Applcation Standards Matrix, Draft project coordination... etc)

 

The table should look something like this:

 

Parent Task, Child Task

Projects, Medium Impact Complaint

Projects, Maintain GO GOP TO and TP Applcation Standards Matrix

Projects, Draft project coordination...

 

Where you make sure to repeat the Parent Task on each record.

 

I hope this helps. Good luck!

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

I'm having a problem with sorting and grouping summary tasks and tasks.  I have multiple projects (P4W) and the download MS P4W dashboard.  I just want a simple way to format the visual in the same way the project does (see below) using expandable hierarchy.   

I can't find a column in the Project Task Table that I can sort by.   Is there a way to create a hierarchy that look similar to projects. 

The subtasks (Projects and Annual Activates) in P4W are not grouped and listed as tasks in the Power BI visual.  

 

PW4

fm114fm_0-1660328448007.png

 

 

 

Power BI

fm114fm_1-1660328448029.png

 

 

KratosBI
Regular Visitor

Good Morning fm114fm,

 

Great question, 

 

To create the hierarchy, you need to shape your data so you have one column for your parent items (Projects, Annual Activities) and one column for all of the child tasks (Medium Impact Complaint, Maintain GO GOP TO and TP Applcation Standards Matrix, Draft project coordination... etc)

 

The table should look something like this:

 

Parent Task, Child Task

Projects, Medium Impact Complaint

Projects, Maintain GO GOP TO and TP Applcation Standards Matrix

Projects, Draft project coordination...

 

Where you make sure to repeat the Parent Task on each record.

 

I hope this helps. Good luck!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.