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.
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:
|Single line of text
|Single line of text
|Single line of text
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.
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.
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.
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.
5. Our group is created in the “Data” panel, “Potz.” Now drag the “Potz” into the Legend field. Check out the screenshot below.
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.
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‘.
Now we successfully add the other category to the pie chart.
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.
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.
Now, go to the Groups dialog box. Select “Aubergine,” “Courgette,” and “Eggplant” in a group, then click ‘OK.’Now, see the result.
Now you can see the small slice in a group.
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.
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.
You can display a Power BI pie chart with multiple values.
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:
Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book Microsoft Power Platform A Deep Dive. She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.