LOADING

Type to search

Getting Started – Your First Bar Chart in Microsoft Power BI

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Getting Started – Your First Bar Chart in Microsoft Power BI

Share

If you are looking for a Microsoft Power BI Corporate Training in Gurgaon , please feel free to reach out at akriti.lal@instrovate.com or whatsapp at +91-9953805788 

 

Now we have installed Power BI Desktop on our local system.

Let’s start with Power BI……. How we can use Power BI for our data. First of all, I will explain how we can import data into our Power BI. Go to Power BI desktop shortcut created on system’s desktop and click on it:

Getting Started - Your First Bar Chart in Microsoft Power BI 29

 

It will take few seconds and will open Power BI.

Now click on the Get Data drop down. It will open the list in which form we can import data in Power BI. We have a long list in which form we can import our data in to Power BI.

 

Getting Started - Your First Bar Chart in Microsoft Power BI 30

 

Click on the More option from drop down options and it will display all option to get data in to Power BI:

 

Getting Started - Your First Bar Chart in Microsoft Power BI 31

 

I have a Sample file in Excel. Let select Excel and click on the Connect button, browse the file path that you want to import:

 

Getting Started - Your First Bar Chart in Microsoft Power BI 32

 

Select the file and click on Open button. It will connect to the file and open file in to Power BI:

 

Getting Started - Your First Bar Chart in Microsoft Power BI 33

Here we can see our sample file with headers names Orders, People, Returns.

Now we need to load the file from this sample file. We can select display option and click on Load button.

 

Getting Started - Your First Bar Chart in Microsoft Power BI 34

It will take few seconds (depend on the file size).

Getting Started - Your First Bar Chart in Microsoft Power BI 35

Now in Fields Pan we can see our Order header is displayed with its different options.

Let’s we draws our first Bar chart for Product ID and Quantity. Select Product id check box (or we can drag and drop required field) from Fields value for Order. It will display values in Report are:

 

Getting Started - Your First Bar Chart in Microsoft Power BI 36

 

Now select or drag and drop Quantity field:

 

Getting Started - Your First Bar Chart in Microsoft Power BI 37

We can see values are present in table form and in Visualization table is selected by default from Power BI.

We will select Bar chart from Visualization options, and it will change report in the form of a Bar Chart:

Getting Started - Your First Bar Chart in Microsoft Power BI 38

Click on Focus mode from the Report:

 

Getting Started - Your First Bar Chart in Microsoft Power BI 39

Clicking on bar’s we can see values for respective fields:

Getting Started - Your First Bar Chart in Microsoft Power BI 40

Here for Product ID is FUR-BO-10000112 and Quantity is 9

 

Getting Started - Your First Bar Chart in Microsoft Power BI 41

 

We can create any other Visualization for different values. now with this same bar chart we will create one more bar chart for Customer ID and Quantity values.

Click on blank space in Report area, selected fields are unselected and now we can select new fields.

Getting Started - Your First Bar Chart in Microsoft Power BI 42

Select Quantity from the fields:

Getting Started - Your First Bar Chart in Microsoft Power BI 43

select Customer ID:

Getting Started - Your First Bar Chart in Microsoft Power BI 44

Move cursor to the bar and it will display values for respective fields:

 

Getting Started - Your First Bar Chart in Microsoft Power BI 45

 

This was our “Getting Started” and our First Hands on creating Bar Chart using Power BI .  We will continue using this and thing will become complex and we will come to know , how to Handle Aggregation , Disaggregation , Working at Different Granularity of Data in Power BI , Working on all the Different Types of Chart available by Default and how we can customize it based on our requirement etc.  So Hang On and keep Cherishing all the small learning , and keep visiting the Space for further learning.

For Corporate training and Online Training contact at info@instrovate.com
Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *