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....
Show and Tell
Tutorial Requests
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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

What happens when you try to build a simple Table visual?  Also, have you tried the Query Editor to create that Table.

  • charlieotonor's avatar
    charlieotonor
    Frequent Visitor
    8 years ago

    Nothing is wrong when  i do the table visual, the only problem is, it still gives me one value per group.

    I havent done it in the query because it will take a lot of time, I have 800,000 rows here. I need a smarter way to solve this problem please.

     

    Can I create two tables for the same value? I dont know