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.
