Power BI Pie Charts are very useful to visualize the High-level data. For example, Sales by Continent or region, Orders by Country, Customers by region, or Sales by Main product Group, etc. Let us see how to Create a Pie Chart in Power BI with example.
For this pie chart in power bi example, we are going to use the SQL Data Source that we created in our previous article. So, Please refer to Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Pie Chart in Power BI
When you click on the Pie Chart under the Visualization section, automatically create a Pie Chart, as shown in the below screenshot.
To add data to Power Bi Pie Chart, we have to add the required fields:
- Legend: Drag the column that you want to display as the legend.
- Details: Please specify the Column name on which you want to partition your Pie Chart. Values split based on this field.
- Values: Any Numeric value, such as sales amount, Total Sales, Customer count, etc.
In this example, we create a Pie chart for Sales Amount by country Names. So, Drag the Sales Amount column to the Values field.
Next, checkmark the English Country Region Name, or Drag and drop it to Legend region automatically create a Pie Chart for you.
Hover over any slice show you the Tool-tip of Country Name and Its Sales Amount
Second Approach to Create a Pie Chart in Power BI
Drag and Drop the Sales Amount from Fields section to Canvas automatically create a Bar Chart, as shown in the below screenshot.
By clicking the Pie Chart in the Visualization, converts the Bar Chart to Pie Chart.
Add the Country Name to legend. Remember, we haven’t added anything to the Details section. So, it considers English Country Region Name (legend) as the Details.
If I add State Provide Name to the Details (explicitly), then Power BI Pie Chart displays the Sales by State province Name, and legend displays the Country Name.
Let me do some quick formatting of this pie chart
NOTE: I suggest you to refer Format Pie Chart article to understand the steps involved in formatting legend, Data Color, Background Color, Title, and Slice colors.
