Group Rows

[Anonymous]

Hello everyone   I am new in the implementation of Power BI, I have been trying to group my rows by similar records for example

CLMN_1  CLMN_2

ITEM A    COMPANY_1

ITEM A    COMPANY_2

ITEM A    COMPANY_3

ITEM A    COMPANY 4

to this format:

ITEM A

          COMPANY_1

          COMPANY_2

          COMPANY_3

          COMPANY_4.

I tried using the "group by function but I'm not getting desireable results, I might be doing something incorrectly. Please help out guys.

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

You could create a hierarchy. In the fields pane, If you drag CLMN_2 field onto CLMN_1 field, the hierarchy will be created. This is how you will create hierarchy.

Regards,

Daniel He

[Anonymous]

Its working, thanks a lot @v-danhe-msft 

---