Forum Discussion
Combine Values into groups
Hello, We have a table containing "Job ID", "Job Type" and "Revenue" (and a lot more - not important). The problem is we have 30+ job types, and we would like to put them into 4 groups. The ...
Right,
Creating a group following the link i posted before should work fine
Use grouping and binning in Power BI Desktop
In short, right click on the column -> New group, in group type choose list and than group them in any way you like
Sample data:
| Job ID | Job Type | Revenue | NEW |
| 1 | Banana | 10 | Fruit |
| 2 | Apple | 4 | Fruit |
| 3 | Grape | 10 | Fruit |
| 4 | Red | 100 | Wine |
| 5 | White | 200 | Wine |
| 6 | Rosé | 150 | Wine |
| 7 | Red | 100 | Wine |
| 8 | Banana | 10 | Fruit |
| 9 | Apple | 10 | Fruit |
| 10 | Grape | 10 | Fruit |
| 11 | T-shirt | 200 | Clothes |
| 12 | Pants | 230 | Clothes |
| 13 | Pants | 250 | Clothes |
| 14 | T-shirt | 200 | Clothes |
| 15 | Banana | 10 | Fruit |
| 16 | Apple | 5 | Fruit |
| 17 | Grape | 7 | Fruit |
| 18 | Red | 120 | Wine |
| 19 | White | 200 | Wine |
| 20 | Rosé | 350 | Wine |
| 21 | Banana | 10 | Fruit |
| 22 | Apple | 5 | Fruit |
| 23 | Grape | 5 | Fruit |
| 24 | T-shirt | 100 | Clothes |
| 25 | Pants | 250 | Clothes |
So the "NEW" column is how I think it could be :)
Right,
Creating a group following the link i posted before should work fine
Use grouping and binning in Power BI Desktop
In short, right click on the column -> New group, in group type choose list and than group them in any way you like
Gordonlilj In this case we need to group based on the total revenue (which is another field). So can't use normal grouping option.
