This Power BI tutorial explains, Power BI chart, how to create a chart by using pie chart visualization using Power BI Desktop. Also, we will discuss: Show
When you build a chart in Power BI using data from different data sources like an excel sheet, a SharePoint list, a word document, etc. for representation there is a lot of option for Power BI visualizations. Here, we will discuss the pie chart and its various functionalities through a step-by-step guide. Table of Contents
What is a Microsoft Power BI Pie Chart?Power BI Pie chart is very useful to visualize the high-level data. It is a circular statistical format that represents the size of the item in one data series. The data points on a Pie chart present 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 For example, let’s have data on products. If we build a Pie chart that represents the total price by product name, it will be shown like this: Example of a power bi pie chartOn the basis of the dimension of the graph, the power bi chart classified into 2 types. One is a 2-D pie chart, a 3-D pie chart. Read: How to create Power BI report from SharePoint list and Power Bi Bar Chart Rules to create a Power BI Pie chartThere are some rules that we have to consider before creating a Power BI Pie chart. Have a look at the following rules:
Key elements of a Pie chartThere are mainly 4 key elements present on a Power bi pie chart. These are:
Read: Power Bi line chart and Power bi area chart. How to create a Power BI Pie chart?Now we will see how to create a pie chart on power bi. For these follow these simple steps: Step-1: Prepare the data, that you used to make visuals. Here we use data based on products sold. You can download it here for your practice Step-2: On Power BI Desktop, go to report page. Click Pie chart under visualizations. Power BI Pie ChartStep-3: In this example, we will create a Pie chart that represents data based on price by product.
This is how to create a Pie Chart on Microsoft Power BI. Read: How to Embed Power BI Report in SharePoint Online Basic formating Option of Power BI Pie chartThere is a number of formatting options are available that can be applied on Pie chart to make it more attractive. For formatting, select Pie chart > click on the format. Basic formating Option of Power BI Pie chartLet’s discuss above formatting options one by one.
Read: How to Create a Dashboard in Power Bi? Display values on Power BI Pie chartIn Power BI, there is a cool feature, when the user mouse over on the different segment of visuals it’s showing a tooltip with the static details. For example: if we mouse over on the laptop segment, the tooltip shows the product’s name with its total sell price. Display values on Power BI Pie chartPower BI Pie chart labelsHere we will discuss about Power BI pie chart label:
There is another option as Display units. Let’s have an example by editing the label style. You can see the difference on the details label in between the above pie chart and this pie chart. (You can customize according to your need) Let’s have another example, here we will edit the Display units. You can see the difference between previous and recent visuals. Display unit on power BI Pie chartRead: Simple and Powerful Power BI dashboard examples Power bi pie chart multiple valuesLet us check out the Power bi pie chart multiple values. Power bi pie chart filterNow we will discuss, power bi pie chart filter and how highlighting works on the Power BI Pie chart. There is a filter pane, on that, we can apply filter and make a highlight on the visual. Let’s follow the step-by-step guide to applying a filter on the pie chart. Step-1: Select the Pie chart visual. Step-2: In filter pane, you can see the option like Filters on this visual(it is only applicable on the selected visual). Lets filtrate a visual that shows the item whose price is less than 18000 and less than equal to 15000. Then the visual look like below: How to do Filter on Power BI Pie chartIn this above filter Pie chart, it will show the product price that comes between 18000-15000. There are two conditional operators, i.e. And, Or. And operator is used, where both conditions must be true between two arguments. Similarly, Or operator is used where one condition is true between two arguments. Let’s take another example, where we apply filter on products. By expanding the filter type, we can see 3 different types of filtering like Advance filtering, Basic filtering, Top N filtering. Filters on Power BI Pie Chart
On the above filter, it showing only Desktop as there is no product that starts with R. This is how an advance filtering on Power BI Pie chart.
For example, we will show only Laptop, desktop, smartphone from total products list. Lets have a look on below visual: Power BI Pie chart Multiple valuesThis is how multiple values show on Power BI Pie Chart. For showing single value on Power BI Pie Chart select Require a single selection.
This is how to do the Top N filter on Power BI Pie Chart. Similarly, you can show the Bottom N products by expanding the show items. Read: How to create Power BI report from SharePoint list + Excel Conditional formatting on power bi pie chartNow we will see conditional formatting on pie chart in Power BI. For implementing this format follow these steps: Example 1: Format by Color Scale Step-1: As there is no option for conditional formatting on the data color of the Pie chart, we will convert this pie chart to clustered column chart. How to convert pie chat to clustered column chartStep-2: Now select the Data colors. Click on function as shown on below: Getting started with formatting data color on Power BiStep -3: It will navigate page, on which we will do the conditions on data color for visual. How to do conditional formatting on Power BI Data ColorsIn this above example, here we set the data colors according to lowest value, middle value, highest value on minimum, center, maximum respectively. Step-4: After clicking OK, the data color will change on the clustered column chart. Also, we can see this chart having conditional formatting. Conditional Format on Power BI Bar ChartStep-5: Now convert this column chart to a pie chart by selecting this visual. It applies the color on each product based on its count. conditional formatting on Power BI pie chartExample 2: Format by Rules Step-1: Similarly, choose Rules by expanding Format by(on selecting the function of bar chart’s data color). Step-2: Here, lets do some Rules based format on on bar chart. How to do Rules based Conditional format on Power BIIn this above format, we applied 2 rules having different colors. Click on OK. It will appear on the chart based on the count of products. Step 3: Similarly, convert the bar chart to pie chart. It will look like below: How to do Conditional format On power BI Pie chartRead: Microsoft Power bi report vs dashboard How to show percentage value in Power bi?Now we will show how to show only percentage value in power bi pie chart. Follow this step by step guide to implement this: Step-1: For example, we will create a pie chart that shows the data as quantity by products. Step-2: Select this visual, go to Format > Details label > Label Style > Percent of total. Now, We can see the only percentage value visualize on the pie chart. Show Only Percentage on Power Bi Pie ChartWe can show the labels(Percentage) inside the pie chart by formatting the Label position > Inside. show percentage and Label Position on power bi pie chartThis is how to show percentage value in Power bi report. How to do drill up and drill down on Power bi pie chart?Let’s see how to do drill up and drill down on the power bi pie chart. In power bi, drill up and drill down on report help you to drill the report in multi-levels. By using this drill up and drill down action we can see the data in each level. Here are the following steps to do drill-up and drill down on the pie chart. Step-1: For implementing this method we will use sample data, which we downloaded from the browser. You can download it or you can prepare your own data according to your need. Step-2: We will create a pie chart using this sample data, which shows the data Total profit by year and product category. The pile chart will look like this. Drill down and Drill Up On power BI Pie chartStep-3: We can do drill up and drill down report using these options:
Step-4: For example, lets go to next in the hierarchy. Then the visual will be look like: How to go Next level hierarchy On Power BI pie chartOn this above visual if you closely notice, the drill-up option is now enabled. which means there is possible to go up. Also, you can notice both the visual, the first one is showing Profit by year and Product category and the second one is showing Profit by Quarter and Product Category. Step-5: Similarly, If we click again on going to next in the hierarchy, we will move up to the next level. i.e. Profit by Month and product category. This visual will be shown like this: Example of go to the next level in the hierarchy on power bi Pie chartStep-6: If we click on drill up(up arrow), then it will move to the previous level or up level. i.e. Profit by Quarter and Product Category. Drill Up on Power bi pie ChartStep-7: To drill down on the Power bi pie chart, select a segment that you want to drill down and click the drill-down button from the context menu. How to do Drill down on power bi Pie chartOn the above visual, if you observe closely, the selected segment divided into profit by month category from profit by year category. This is how to do drill down and drill up on power bi pie chart. Aadvantages and disadvantages of Power bi pie chartHere we will discuss what are the advantages and disadvantages of power bi pie chart. Advantages of the power bi pie chart:
Disadvantages of the power bi pie chart:
You may like the following Power BI tutorials:
ConclusionFrom this above tutorial, we learned how to create a Power Bi Pi chart? Also, we discussed:
Bijay Kumar After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Out audiences are from the United States, Canada, United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a SharePoint MVP(8 times), check out My MVP Profile. I have also worked in companies like HP, TCS, KPIT, etc. How do you show all data labels in a power bi pie chart?Format the Label position from “Outside” to “Inside” and switch on the “Overflow Text” function, now you can see all the data label. If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. This helped , thank you!
How do you show all labels on a pie chart?Click the chart, and then click the Chart Design tab. Click Add Chart Element and select Data Labels, and then select a location for the data label option. Note: The options will differ depending on your chart type. If you want to show your data label inside a text bubble shape, click Data Callout.
How do you display outside end data labels on a pie chart?To display data point labels outside a pie chart. Create a pie chart and display the data labels.. Open the Properties pane.. On the design surface, click on the pie itself to display the Category properties in the Properties pane.. Expand the CustomAttributes node. ... . Set the PieLabelStyle property to Outside.. |