Pie chart in Power BI

Do you want to learn how to create a Pie chart in Power BI? In this Power BI tutorial, we will see what a pie chart is and how to create a Pie chart in Power BI. Also, we will see how to add multiple values to the pie chart.

Here, we will cover the related topics below:

  • What is a pie chart in Power BI?
  • How to create a pie chart in Power BI
  • Power BI pie chart with multiple values.

What is a pie chart in Power BI?

  • A pie chart in Power BI is a type of visualization that displays data as circular pie slices. The data points on a Pie chart are presented as a percentage of the whole pie. The total value of the Pie chart is 100%. The formula of Pie chart =( given data / total data)*360
  • Each slice represents a category or a part of a larger dataset, and the size of each slice is proportional to the value it represents relative to the total.
  • Pie charts are effective for visualizing data that shows the relative proportions of different categories within a dataset.
  • They are frequently used to represent the distribution of sales by product category or the breakdown of a budget by spending type.

How to make a pie chart in Power BI

Here, we will see how to create a pie chart in Power BI.

To create a Power BI Pie chart, we will use the Financial Excel sheet data. You can download and use the same Excel for it.

From this Excel data, we will use the Segment column [contains values: government, Small Business, Enterprise, Mid-market, and Channel Partners] and Sales column in the Pie chart to display the Sum of sales based on the Segment.

how to create pie chart in power bi
  • Open Power BI Desktop, and then click on Excel Workbook, or you can click on Get data -> select Excel Workbook.
how to make pie chart in power bi
  • Then select the Excel sheet from your local system; in the Navigator window, select the table and click on the Load button.
power bi pie chart show values
  • Now, select the Pie chart from the visualization pane.
  • You can see the blank pie chart in the Power BI Desktop canvas.
pie chart power bi

There are mainly 4 key elements present on a Power bi pie chart. These are:

  • Title: The title gives short information about the visual. It can be customized to give brief information about the chart. It helps the user to identify what they are about to look at.
  • Legend: The legend tells information about each slice that is represented on the pie chart.
  • Label: In a pie chart, the data represents the part of the total, i.e., 100%, and each slice of the chart has a different piece of data. It presents as a percentage of the total pie.
  • Data: The data that we used to create a visual.
  • Next, we will add the data to the Power BI Pie chart, for this, follow the steps:
    • Drag and drop the Segment column to the Legend field.
    • In the Values field, drag and drop the sales column
what is pie chart in power bi

Now, you can see the Power BI pie chat that is displaying “Sum of Sales by Segment”.

This is how to create the pie chart in Power BI Desktop from an Excel file.

Power BI Pie chart multiple values

Here, we will see how to display multiple values in the Power BI Pie chart.

As in a Power BI Pie chart, we can show a single data value, but if you want to show multiple values, then we need to use multiple pie charts, or by adding the values to the tooltip, we can display multiple values.

For example, we will show the Sales and Profit value based on Segment. If I add the Sales and Profit Columns to the Value field and Segment Columns to the Legend. Then, it will only show the Sales value based on Segment.

power bi pie chart

To solve this issue we will add the Profit column to the Tooltips field, then it will display the value of Sales and Profit based on Segment in the Power BI Pie chart.

Let’s see how to display multiple values in a Pie chart.

  • In the Power BI Pie chart, we will show the sales and profit based on the segment; for this, drag the segment to the legend, then drag the sales to the Values field and drag the profit column to the Tooltip.
pie charts in power bi

This is how to show multiple values in a Power BI pie chart.

Pie chart advantages and disadvantages

Here are some advantages and disadvantages of Power BI.

Advantages:

  • The pie chart is a simple and easy-to-understand visual.
  • A minimal additional explanation is required.
  • Easily summaries a large data set in a visual.
  • The circle size can be proportional to the total quantity it represents.
  • Visualize simpler as compared to other visuals.

Disadvantages:

  • If too many data are sliced on the pie chart, then it will be difficult to recognize.
  • It does not take negative values.
  • It may be needed to show changes over time.
  • It does not easily reveal the exact value.
  • It fails to reveal key assumptions.

Conclusion

In this Power BI tutorial, we covered the below topics:

  • What is a pie chart in Power BI?
  • How to create a pie chart in Power BI
  • Power BI pie chart with multiple values
  • Pie chart advantages and disadvantages

You may also like:

>