Forum Discussion
Table structure
- 4 months ago
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
Thanks