Forum Discussion
Table structure
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
A disconnected helper table is a small table you manually create in Power BI to help organize your Matrix columns. Disconnected means it doesn’t have any relationships with your main data tables it’s mainly for display.
For your scenario, where you want grouped columns like DC Inventory → 100K, 200K, 300K, Power BI doesn’t natively support this layout with multiple measures. That’s why we use a helper table to set up the structure. This table can be used in the Matrix columns along with a SWITCH measure to show the right values for each grouping.
I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.
8 Replies
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.
I'd lke to try this but I dont understand this part: create a small disconnected helper table.
Coul you explain it in detail?A disconnected helper table is a small table you manually create in Power BI to help organize your Matrix columns. Disconnected means it doesn’t have any relationships with your main data tables it’s mainly for display.
For your scenario, where you want grouped columns like DC Inventory → 100K, 200K, 300K, Power BI doesn’t natively support this layout with multiple measures. That’s why we use a helper table to set up the structure. This table can be used in the Matrix columns along with a SWITCH measure to show the right values for each grouping.
I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.
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-Columns-and-Measures-are-great/ba-p/4350930
ThanksHi 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], ... )Sounds great, but I dont get the disconnected table, how do i have to create that table?
Hi MikeR9 ,
Could you please confirm if the issue is resolved or if you need more information or clarification.
Thank you.
Hi MikeR9 ,
Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.
