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
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