In this brief blog we are going to look at the steps to create a percentage Pie graph in Power BI. We are going to work with a Human Resource data source that includes the training costs of a company. We are going to create a small interactive dashboard that displays the number of employees trained, and the total training cost. In addition we are going to display the number of employees trained by gender. We are also going to display the training cost by department as a column graph.
The first step is to load the training data into Power BI and to create the interactive dashboard. We have used Card visualizations to display the number of employees trained and total training cost. As previously mentioned the training cost by department is shown as a column graph and the pie graph displays the number of employees trained by gender.
The dashboard displays the number of employees trained by gender. The graph would be much more useful if it displayed the percentages on the pie graph. Power BI has introduced a great new feature called the Quick Calc. The Quick Calc calculates the percentage of the grand total and can be displayed on the pie graph. To calculate the percentage, select the value and select Quick Calc. The Show Value As is changed to percentage of grand total. The pie chart formatting option is also changed. In the formatting option select the details label. Change the label style to both. This will display the percentage on the graph.
The interactive dashboard can be filtered to display only one gender. Click on the Female gender.
Another option is to click on one of the departments and this will display the percentage of number of employees trained for that department in the pie chart.