Power BI Pie Chart Group Small Values

This Power BI tutorial will help you work with Power BI Pie Chart Group Small Values.

We recently worked on a Power BI Pie chart where we found a small value present in the data set but not in the Power BI Pie chart. The solution is to group small values in a Power BI pie chart.

We will guide you on creating groups in the Power BI pie chart and adding items to the group. Also, we will learn how to use the Power BI pie chart for other categories. Also, the pie chart has multiple values.

What is Power BI Pie Chart Group Small Values

In Power BI, when we create a pie chart to show data, sometimes we have small pieces that are hard to see. To clarify, we can group these small pieces into one category. This way, our pie chart is easier to read.

The left side pie chart shows the small pieces. After adding these pieces into one group, the pie chart looks like the right side.

Power BI Pie Chart Group Small Values

How to Create a New Group in Power BI Pie Chart

We will see how to create a new group in the Power BI Pie chart.

We have a SharePoint list used for this pie chart example. The SharePoint list contains the columns below with various data types. See the screenshot below:

ColumnsData Types
RegionSingle line of text
Product IDSingle line of text
Product NameSingle line of text
SalesCurrency
QuantityNumber
DiscountNumber
ProfitCurrency
Group small values in Pie Chart - Power BI

I hope you open Power BI Desktop and load the data using the get data option.

1. Here, I have created a pie chart. The “Legend” field contains the Product Name, and the “Values” field contains the Sum of Quantity data.

Power BI Add Category 'Other' to Charts

2. In the ‘Legend’ field, “Product Name” is present; click the right-side down arrow. Then, a dialog box is opened. In this box, click the “New group” option. Check out the screenshot below.

Create Groups in the Power BI pie chart

3. Then another dialog box, “Groups,” opened. Here, you can create a group. Let’s create a group. Enter the group name, like ‘Potz,’ Then select the item by “ctrl + click” like ‘Aeromint Potz,’ and ‘Rolo Potz.’ Click the Group option.

Power BI pie chart grouping

4. Then, in the “Groups and members” section, group members are displayed. Click “OK” to create a group. If you remove the member, click on the member and click the Ungroup option.

Create a Pie chart with the group

5. Our group is created in the “Data” panel, “Potz.” Now drag the “Potz” into the Legend field. Check out the screenshot below.

group small values in the Power BI pie chart

You can create a group in the Power BI Pie chart.

Power BI Add Category Other to Charts

Here, we see how to add other categories to the Power BI pie chart. Now, we create an ‘Other’ category in the same window and do the below steps.

1. Click the down arrow under the Visualizations panel -> click Edit groups.

Add other categories to the pie chart in Power BI

2. The Groups dialog box opens. In this, check the Include Other group checkbox. Now, the other group contains all ungrouped values. Then click on ‘OK‘.

Power BI pie chart group small values

Now we successfully add the other category to the pie chart.

Power BI Pie Chart other categories

In this way, you can add other categories to the pie chart.

Add Power BI Pie Chart Group Small Values

Now, we will see how to group small values in the Power BI pie chart.

For example:

We have a pie chart that shows the ‘Sum of Quantity by Product.’

In the Pie chart, Aubergine, Courgette, and Eggplant are in small quantities. We add these three products to one group. Check out the screenshot.

Power BI pie chart small value add one group

Now, go to the Groups dialog box. Select “Aubergine,” “Courgette,” and “Eggplant” in a group, then click ‘OK.’Now, see the result.

power bi pie chart combine values

Now you can see the small slice in a group.

pie chart small value add one group in Power BI

In this way, you can group small values in the Power BI pie chart.

Power BI Pie Chart Multiple Values

We can display two values simultaneously in the Power BI Pie chart.

To do this, In the Visualizations pane, click the Pie chart -> Then drag and drop Product Name into the Legend field. -> Next, drag and drop Profit and Sales into the Values fields.

Power BI pie chart multiple values

You can see a white line separating the slice into Sales and Profit. You can see details in the tooltips when you hover over the slice.

Power BI pie chart two values

You can display a Power BI pie chart with multiple values.

Conclusion

I hope this tutorial helps you a lot. This tutorial taught us the Power BI pie chart group small values and how to create a new group in the Power BI Pie chart.

Also, we see how to add other categories in the Power BI Pie chart and how to add the Power BI Pie chart group small values. Additionally, we explained Power BI Pie Charts with multiple values.

You may also like: