I have a bunch of data with "groups" that have customers and revenue received from each of those customers.
I want to be able to sum those groups and display each of their revenue in a bar graph (easy enough) but I also want to display the biggest customer for each group somewhere on the graph, perhaps in the axis names as in the dummy example attached. I want to be able to do this in Power Query, as that is how I'm currently combining all of my real data, but I'm not really sure how to do this. I'm also not sure how to google search for a solution because I don't really know what this would be called. How do I group by the "group" column, sum up the revenue, and also create a column that shows the biggest customer for each group?
Bookmarks