Forum Discussion
Combine Values into groups
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
Hi,
You could try and create a group:
Use grouping and binning in Power BI Desktop
But as says posting some sample test data could be useful to give a accurate solution
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 :)
Thanks Anonymous for sample data.
Is NEW column is your expected output ? or that is what need to considered for JobType to calculate Revenue - Please confirm.
Anonymous Hope this is what you are after..
Create a New Table as below
Test310Out = SUMMARIZE(Test310Groups,Test310Groups[JobType],"Revenue",SUM(Test310Groups[Revenue]))
Then, add Rank field to the above table as below
Rank = RANKX(Test310Out,Test310Out[Revenue],,DESC,Dense)
Finally, add a Grouping field based on the Revenue (which we have assigned Rank in above step)
Group = IF(Test310Out[Rank]<=5,"Type A",IF(Test310Out[Rank]<=10,"Type B","Other"))
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.
