groups

Hi Dirk_Kuypers,

You can achieve it in Power Query by unpivoting the columns then you can use them as groups.

this is your table.

| Eqp.1(6) | Eqp.2.1 | Eqp.2.2 | Eqp.2.3 |
| -------- | ------- | ------- | ------- |
| Group A  | 101     | 102     | 103     |
| Group B  | 201     | 202     | null    |

after unpivoting you'll have something like this 

| Group Name | Equipment |
| ---------- | --------- |
| Group A    | 101       |
| Group A    | 102       |
| Group A    | 103       |
| Group B    | 201       |
| Group B    | 202       |

And now you can use them as groups in matrix view

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!