Merging and Grouping

[Anonymous]

How can i categorized or merge my value into different sector as shown below. 

Position	Role	Room
Professor	Teaching	1
Helper	Helping	2
Staff	Worker	3
Technician	Tech support	4
Chef	Dining	5
Assistant	Account	6
Dean	Support	7

I want to make like this:

Position                       

    Up Stairs

            Dean

            Assistant

   Middle Floor            

             Professor

             Technician

    Low Stairs

          Helper

          Technician

[rajendraongole1 · Accepted solution]

Hi @Anonymous - you can achieve the above grouping using grouping in Power BI

you can group the categories as below by selecting the field position.

Right click on the field that you want to perform group as below

you can create the groups name as per your requirement

after creating the grouping , in your table the grouped category looks in below way. 

Hope this helps.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!