Forum Discussion
Impactful IndividualTable with dynamic grouping of rows
Use a matrix visual, ensure that your data groups the items accordingly.
e.g. you have a column that identifies level1 grouping and level2 items.
Add both items to rows and expand all
--------------------------------
I hope this helps, please give kudos and mark as solved if it does!
Connect with me on LinkedIn.
Subscribe to my YouTube channel for Fabric/Power Platform related content!
Power BI doesn't have an option to group rows in a table visual, so all rows are displayed in a flat structure. A matrix visual can partially achieve the layout you're after, but each field added to the row hierarchy is displayed on a new indented level rather than on the same row as the preceding field. Any remaining values would need to be added as measures, which is limiting because measures require aggregation and therefore can't display individual, distinct row values.
Super UserHello powerbiexpert22,
For this kind of layout, go with a Matrix visual not a Table.
Set Phase as your first Row field, Milestone as the second, you'll get the grouping and expand/collapse for free.
The orange header styling though? That's not something the native Matrix can do.
You will need a custom visual or Paginated Report to get there.