Pie Chart in Power BI
Drag the Pie chart icon from the “Visualizations” pane to the Report view Canvas of Power BI desktop. The initial pie chart in the canvas looks like the following.
Initial chart:
Example 1
In this example, we will learn to get a pie chart which shows Sum of “Sale_amt” based on different brands “Brand”. Set the “Visualizations” pane as shown below by dragging the relevant fields from the “Data” pane from the “SaleData” dataset as mentioned earlier in the previous section of this article.
Output: We get the following pie chart which provides details about different brands in multiple colors with the percentage value contribution for each brand.
Example 2
The following example demonstrates Sum of “Sale_amt” categorized by “Item” further categorized by respective “Brand” of that particular item. The following shows the setting of the visual pane.
Output: The following shows the Sum of “Sale_amt by Item and Brand” with respective details. the user can hover on any pie for selective information.
Video output:
Example 3
This example shows that the pie charts can be displayed in combination with any other Power BI charts for implementig cross-filter feature. Refer to the “Power BI – filters” article for better understanding before starting this.
Let us consider a pie chart of “Sum of Sale_amt by brand” and “by Month”. For “Sum of Sale_amt by month” , we will be considering Power BI bar charts. Drag the bar chart icon to the report canvas next to the pie chart of “Sum of Sale_amt by brand” and set the visual plane as shown below by dragging relevant fields from data pane.
Output: We get the following result clicked on “October” and pie chart result is based on the month selection.
Video output: The following shows the changes that take place when the user changes month from the bar chart. Refer to the article “Understanding filter in Power BI”. Notice the changes when the months selection is changed.
The above pie chart label contents can be changed by setting following “Visualizations” pane for some change in UI pie chart.
Output:
Power BI – Create Pie and Donut Charts
In this article, we will learn to create Pie and Donut Charts using Power BI.
Contact Us