Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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)
Have you considered using a Gantt chart visual for this?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 2 | |
| 1 | |
| 1 |