Forum Discussion

Dirk_Kuypers's avatar
Dirk_Kuypers
Frequent Visitor
4 months ago
Solved

groups

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?

 

Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    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!

3 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    4 months ago

    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!

  • v-tejrama's avatar
    v-tejrama
    Community Support
    4 months ago

    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's avatar
      v-tejrama
      Community Support
      3 months ago

      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.