WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn Power BI » Power BI Pie Chart

Power BI Pie Chart

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.

Power BI Pie Chart

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 Excel, and now we will see how we can create the same in Power BI.

Power BI Pie Chart Visual

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.

You can download this Power BI Pie Chart Excel Template here – Power BI Pie Chart Excel Template

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.

Pie Chart Excel Table

  • Upload the above data table to Power BI.

Power BI Pie Copy Paste Data

  • Open the Power BI file, go to the HOME tab, and click on “Enter Data.”

Pie Chart Enter Data

  • This will open up the “Create Table” window.

Power BI Pie Chart Create Table

  • Place your cursor on the first cell, i.e., “Column1” and paste it. Next, give a name to the table as “Pie Table.”

 Copy Table with Name

  • Click on “Load” to get the data to Power BI, and under the “Data” tab, it will show.

Power BI Pie Chart Data Tab

  • Come back to the “Report” tab and insert the blank “Pie” chart.

 Chart Tab Report

  • As soon as you insert the Pie chart, we could see its fields as well to the right side.

Power BI Pie Chart Fields

  • Legend: This is nothing based on what column values we need to see the pie chart. In our example, we need to see the “Region-wise” pie chart. Our legend will be the “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 the “Region” column to the “Legend” field.

Chart Drag Region

  • As of now, our Pie chart is still a blank one.

Power BI Pie Chart Blank

  • Now drag and drop the “Sales” column to the “Values” field.

 Drag Sales

  • Now our chart looks like below.

Power BI Pie Chart View

  • Now just hover on any of the slices of the pie to see data values.

Chart Hover

In the above image, I just hovered on the “yellow” slice, and it shows the region name as “West” and “Sales” value as 250128, and also it shows the percentage contribution as 34.11%.

Popular Course in this category
Sale
Power BI Training Certification
4.5 (521 ratings)
6 Online Courses | 29+ Hours | Verifiable Certificate of Completion | Lifetime Access
View Course
  • However, imagine a situation where we need to see “Cost” as well. For this, add the “Cost” column to the “Tooltips.”

Power BI Pie Chart Tooltips

  • Now hover on any of the slices of the pie and see the magic.

Cost Field Hover

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.

Power BI Pie Chart 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 turns on this feature.

 Legend

  • 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…”

Power BI Pie Chart Formatting

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.

 Pie Chart Image

Note: Power BI Pie Chart file can also be downloaded from the link below, and the final output can be viewed.

You can download this Power BI Pie Chart Template here – Power BI Pie Chart Template

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.

Recommended Articles

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 –

  • Power BI Filter Function
  • Parameter in Power BI
  • Power BI GroupBy Dax Function
  • Rotate Excel Pie Chart
  • Power BI LOOKUPVALUE
0 Shares
Share
Tweet
Share
Power BI Training Certification
  • 6 Online Courses
  • 29+ Hours
  • Verifiable Certificate of Completion
  • Lifetime Access
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Download Power BI Pie Chart Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Power BI Pie Chart Excel Template

New Year Offer - Power BI Training Certification (22+ Hours of Training) View More