Forum Discussion
Solved
How to create a table inside another table in Matrix with separate column headers
Hi everyone, I’m building a Matrix visual in Power BI where each Vendor expands to show its Categories. When I expand a Vendor, I’d like to see a header row called “Category” before the list of c...
Hi Elizabeth190803 ,
As Poojara_D12 mentioned, the built-in Matrix visual can’t insert a custom row header like “Category” under each Vendor the best you can do natively is simulate it (turn off stepped layout or use a UNION table).
If you need it to work exactly as described (a true header row under each Vendor), you’ll need either:
- Paginated Reports (RDL) these support group headers out of the box. You can group by Vendor, then insert a header row labelled “Category” before listing the categories.
- Or a custom visual such as Inforiver Matrix or Xviz Matrix, which provide nested headers and table-within-table formatting that the native Matrix lacks.
Thanks,
Akhil.
Hi Elizabeth190803 ,
As Poojara_D12 mentioned, the built-in Matrix visual can’t insert a custom row header like “Category” under each Vendor the best you can do natively is simulate it (turn off stepped layout or use a UNION table).
If you need it to work exactly as described (a true header row under each Vendor), you’ll need either:
- Paginated Reports (RDL) these support group headers out of the box. You can group by Vendor, then insert a header row labelled “Category” before listing the categories.
- Or a custom visual such as Inforiver Matrix or Xviz Matrix, which provide nested headers and table-within-table formatting that the native Matrix lacks.
Thanks,
Akhil.