Pie Chart in Power BI
Pie Chart in Power BI is a built-in visualization chart available with all versions of Power BI. Pie Chart is a round-shaped circle chart where each category data sets are shown in pie shape based on the value of each data label. Pie Chart of each category is adjusted against the overall portion of the data labels.
Visuals are eye-catching and can convey the message better than the table alone can tell the story with numbers. So in dashboards, you could see many visuals than table format summary. One such visual which could be eye-catching is the “Pie” chart. We all have created a Pie Chart in MS Excel and now we will see how we can create the same in Power BI.
How to Create Pie Chart in Power BI?
You can download the workbook used in this example to practice along with us from the below link.
In order to create a Power BI chart, we need data set with a minimal number of data labels. Below is the data we are going to use to create a PIE chart.
- Upload the above data table to Power BI.
- Open Power BI file, go to HOME tab and click on “Enter Data”.
- This will open up the “Create Table” window.
- Place your cursor on first cell i.e. “Column1” and paste it. Next, give a name to the table as “Pie Table”.
- Click on “Load” to get the data to Power BI and under the “Data” tab it will show.
- Come back to the “Report” tab and insert the blank “Pie” chart.
- As soon as you insert the Pie chart we could see its fields as well to the right side.
- Legend: This is nothing based on what column values we need to see the pie chart. In our example, we need to see “Region-wise” pie chart our legend will be “Region” column from “Pie Table”.
- Details: If you want to show any further partition of the data you can add here, we will come back to this in the second example.
- Values: This is nothing but what numerical value we need to show in the pie circle.
- Tooltips: This is nothing but adding an extra element to the pie chart when we hover on any of the slices of the pie.
Now first drag and drop “Region” column to “Legend” field.
- As of now, our Pie chart is still a blank one.
- Now drag and drop “Sales” column to “Values” field.
- Now our chart looks like below.
- Now just hover on any of the slices of the pie to see data values.
In the above image, I just hovered on “yellow” slice and it shows the region name as “West” and “Sales” value as 250128 and also it shows percentage contribution as 34.11%.
- However imagine a situation where we need to see “Cost” as well, for this add “Cost” column to the “Tooltips”.
- Now hover on any of the slices of the pie and see the magic.
Since we have added “Cost” to the “Tooltips” we could be able to see “Cost” as well.
Formatting of Pie Chart
By default, Pie Chart looks like the above one but we can format this to make it look even more beautiful.
- Select the chart and click on the “Format” tab.
As we can see above we have plenty of formatting options. We will show you one of those in detail.
- Legend: This is nothing but we have each slice in different colors and each color represents different Regions, to see which color represents which region turn on this feature.
- When you further click on the down arrow of this option we can see other formatting options regarding “legends” as “Position, Title, Color, Font, Size, etc…”
Like this, we have several other formatting options so you can choose each of those and experiment to see its impact.
- I have made some of the formattings to the pie chart. Now it looks like below.
Note: Power BI Pie Chart file can also be downloaded from the link below and the final output can be viewed.
Things to Remember here
- Pie Chart in Power BI is a built-in chart.
- It is a simple chart with drag and drop options.
- Do not use Pie chart when the data labels are more than 10.
- Always format the Pie chart to make it look better, beautiful, and eye-catching.
This has been a guide to power bi pie chart. Here we discuss how to create a pie chart in power bi with an example and downloadable template. You may learn more about Power BI from the following examples –