I'm trying to use a matrix table to display projects, summary tasks and tasks in a drill down to expand and collapse at each level.
This is the project level from the project table.
But when I expland the project, the summary tasks are at the same level of all the tasks and sorted alphabetically.
It should look like this.
How can I get a matrix to look like the project. Here is what I have (initiative is rename from Project Name)
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
