Forum Discussion
Merging and Grouping
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 |
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!!
1 Reply
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!!