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 goal is to look at revenue per job type - so instead of revenue per 30+ job types, we would like to see the revenue per 4 combined types.
So lets say Job type 1-10 Should belong to "Jop Type A", Job type 11-20 should be "Job Type B" etc.
Is there an easy way for us to do that in this huge data table?
Thanks!
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
7 Replies
Anonymous Please post sample test data to suggest an accurate solution. But from the lines of your requirement, I suggest to create a Rank field which will give you the rank based on their Revenue and then use this Rank field to create a groups using DAX
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.
