Pie Chart in Power BI

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. In this article we will show you, How to Create a Pie Chart in Power BI with example.

For this we are going to use the SQL Data Source that we created in our previous article. So, Please refer 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 will automatically create a Pie Chart as shown in below screenshot.

In order to add data to Pie Chart, we have to add 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 you Pie Chart. Values will split based on this field.
• Values: Any Numeric value such as sales amount, Total Sales, Customer count etc.

In this example, we will create Pie chart for Sales Amount by country Names. So, Drag the Sales Amount column to Values field.

Next, check mark the English Country Region Name, or Drag and drop it to Legend region will automatically create a Pie Chart for you.

Hover over any slice will 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 will automatically create a Bar Chart as shown in below screenshot.

By clicking the Pie Chart under the Visualization section will automatically convert the Bar Chart to Pie Chart

Add the Country Name to legend. Remember, we have’t added anything to Details section so, it will consider English Country Region Name (legend) as the Details. If I add, State Provide Name to the Details (explicitly) then Pie Chart will display the Sales by State province Name, and legend will display the Country Name.

Let me do some quick formatting

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.

Thank You for Visiting Our Blog