Forum Discussion

MikeR9's avatar
MikeR9
Microsoft Employee
4 months ago
Solved

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...
  • V-yubandi-msft's avatar
    V-yubandi-msft
    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.