Forum Discussion
PBI table visualization with unique Order IDs from one table and concatenated Items from another tab
You cannot build nested layouts like that with Power BI Desktop (at least not with the default visuals).
Paginated reports can do your layout as-is, https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/nested-data-regions-report-builder.
It is not easy as Tableau, agreed!
Similar layout but not same: Out of curiousity, did you try this using matrix ?
1) Assuming you have the relation between header and detail table using order id.2) Drag a matrix layout and add all the fields in the Rows (and not in columns and not in values)
3) Adjust the settings:
4) Expand to the lowest level: in the matrix visual:
Sample output
and adjust the borders per your needs:
Hope it helps!
You cannot build nested layouts like that with Power BI Desktop (at least not with the default visuals).
Paginated reports can do your layout as-is, https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/nested-data-regions-report-builder.
It is not easy as Tableau, agreed!
Similar layout but not same: Out of curiousity, did you try this using matrix ?
1) Assuming you have the relation between header and detail table using order id.
2) Drag a matrix layout and add all the fields in the Rows (and not in columns and not in values)
3) Adjust the settings:
4) Expand to the lowest level: in the matrix visual:
Sample output
and adjust the borders per your needs:
Hope it helps!
Thank you so much for taking the time to respond. I had built a matrix but didn't know you could remove the row header icons "+/-". I have also used CONCATENATEX to merge values but this is much faster. Really appreciate the help!
Glad to hear that it helped. Thank you.
