Table structure

[MikeR9]

Hi Everyone

I need help to replicate the same table/matrix  structure

The values on column Program is a field from one of my tables
The values on column DC Inventory are 3 different measures, the same case for remaining inventories 

[cengizhanarslan]

You can get close with a Matrix, but not that exact layout natively if each header group (like DC Inventory, Purchase Orders, etc.) contains multiple different measures under it. The usual workaround is to create a small disconnected helper table with columns like Category and Metric, put those on the Matrix columns, and then use a SWITCH() measure to return the correct underlying measure for each combination.

[MikeR9]

I'd lke to try this but I dont understand this part: create a small disconnected helper table.
Coul you explain it in detail?

[krishnakanth240]

Hi @MikeR9 

Using a Matrix visual + disconnected table + SWITCH measure.
Work around is try creating a helper table with Category(DC Inventory, Purchase Orders, etc) & Metric(100K, 520K, etc) then create a measure like
Matrix value = SWITCH(SELECTEDVALUE(MatrixColumns[Metric]), "100K", [Measure_100K], "520K", [Measure_520K], ... )

[MikeR9]

Sounds great, but I dont get the disconnected table, how do i have to create that table?

[Natarajan_M]

Hi @MikeR9 , We can't replicate the shared table format using the built-in table or matrix visuals. You can use SVG to achieve this.

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/SVG-based-Power-BI-Semantic-Model-...

Thanks