groups

[Dirk_Kuypers]

Hello,

I want to create groups from following tabel. I need from column "Eqp.1(6)" the group name and then every number from "Eqp. 2.1" , "Eqp.2.2",... should be in this group.

Is there a simple way to do this?

[v-tejrama]

Hi @Dirk_Kuypers ,

Thank you @grazitti_sapna for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you

[v-tejrama]

Hi @Dirk_Kuypers ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[grazitti_sapna · Accepted solution]

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!