What’s my favourite:
Here’s my initial data inside Excel:
Excel does a reasonably good job when you only have 9 rows to chart. Select your data, click Insert from the Ribbon and pick a chart. Easy, right?
Here’s the Excel chart created:
Everything’s fine so far. However, now let’s assume that the above never happened!
Instead, the data has come to you in a slightly different format:
This time there are 20 rows to chart … this doesn’t work out quite so well on our chart!
We have 20 categories! That’s quite frustrating on a number of fronts:
(1) No aggregation of count by country.
(2) Within the Country column there are repeating values. i.e. Brazil have won the FIFA World Cup quite a few times. Each time it wins, Brazil gets another category on my Excel chart’s horizontal category axis. There should really only be a single category for Brazil.
(Now, I know you could take the Pivot Table and Pivot Chart route within Excel but say you don’t really like doing it that way or actually aren’t particularly familiar with it.)
Enter Power BI … the fantastic new “spreadsheet-like” program from Microsoft, the creators of Excel:
Once your data is imported into Power BI using its Power Query component, you can start working with Power BI’s Visualizations and Fields panes:
Click Clustered Column, link Count to Value and Country to Axis.
Power BI instantaneously creates a list of unique items from repeat items within the Country column and also, by means of a process I call “FilterIn”, plots the number of times each of the 9 countries has been a winner. (This post was written on 25 June so no winner just yet for 2018!):
You end up with a very neat and concise visual as presented above or you could turn it into a nice Map visual: