PowerBi Basics – Displaying data from .csv file

Recently I’ve been working with Microsoft’s data visualization tool, PowerBI, and I’ve been experimenting with the basics of getting data from various sources and displaying the information in a more appealing format.

One of the easiest methods to test out was from .csv/excel files. In order to do this, you just select ‘get data’ from the main menu and connect to your file. In my example below, I’ve used some pokemon data from Kaggle.com.

Once this is loaded in, you should notice a panel on the right side which displays all the fields you have available. For this example, I’m going to select the pokemon number and some stats. In the visualisations panel next to it, you should arrange your data so that ‘name’ is under axis, ‘#’ is under tooltips and everything else is under values.


Now if we select the first which is a stacked bar chart, you should see something that looks like this:

Which looks pretty good, but it’s currently showing all generations of pokemon. If we add the ‘generation’ field to tooltips and scroll down in the visualisations panel, we can use the ‘filters’ to only show items where generation equals 1. (and also filter out ‘mega’). If you’ve applied these filters you should see this:

Thanks for reading, I’ll be posting more information around the basics of PowerBI soon.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s