Dataset
The dataset used is “SalesData.xlsx“. Upload the dataset in Power BI and refer to the dataset to follow along with the below-given sections of the article.
The user can take a general idea about the data fields of the above dataset.
Data
We will be working with “SaleData.xlsx” data with data fields as shown in the above image. The major variables used to show the charts are as follows.
- Item: This is the item names. This is the variable for which the sale is shown in the form of pie or donuts.
- Brand: This is the brand name for any particular item.One item can belong to different variety of brands.
- SaleAmt: This is the total amount sold ( shown in Indian “Rs”).
- Region: Whether the sale is in the “Central”, “East” or “West” region.
Load Data in Power BI Desktop
Open Power BI Desktop
Click the “Get Data” option and select “Excel” for data source selection and extraction.
Select the relevant desired file from the folder for data load. In this case, the file is “SaleData.xls”. click the “Load” button once the preview is shown for the Excel data file.
The dashboard is seen once the file is loaded with the “Visualizations” Pane and “Data fields” Pane which stores the different variables of the data file.
Data Pane:
In the “Visualizations” pane, we can select the chart type needed for our visual representation of business data. In the following image, the red colored square represents the “pie” and “donut” chart that can be dragged for the “Report” view for further process.
We are dealing with simple examples for both the charts. Kindly refer to the following articles for formatting changes and setting for a different look and feel as per your requirement.
For format of Pie charts, refer to the link.
Power BI – Create Pie and Donut Charts
In this article, we will learn to create Pie and Donut Charts using Power BI.