Forum Discussion

charlieotonor's avatar
charlieotonor
Frequent Visitor
8 years ago

Group by

Hello Beautiful People,

 

Please I have a quesion. How can I group values into multiple groups in power bi.

Example, I have a value in a "manager column" and this value manages two groups at once.

 

However, Power Bi only lets you group one value per group from the modelling tab.

 

How can I do achieve my result please?

Show and Tell
Tutorial Requests

7 Replies

    • charlieotonor's avatar
      charlieotonor
      Frequent Visitor
      8 years ago

      Current tableExpected resultI want the component body to be in two or more groups. When I use the group by function in poower bi, It only allocates it to one group. How can I achieve my result please?

      Thank you

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi charlieotonor

         

        For this the best option is use DAX, in this case you can use SUMMARIZE, but this option is for create a new table, if you want to do it on the current table you should do it on the EDIT QUERIES and there is an option called GROUP BY.

         

        Good Luck.