a pie chart that creates an "Others" group

[Sylvine_Wyz]

Good morning,

I need to create a pie chart that creates an "Others" group when the value is less than 3%.

Could you help me please ?

THANKS

 Tables : 
bi_order :
- EAN
-Quantity

Catalog_ean : 
-EAN
-Brand

[v-weiyan1-msft]

Hi @Sylvine_Wyz ,

I am not sure how your semantic model looks like.
Based on your description, I tried to create some dummy data.

Please try code as below to create a Calculated column.

Category Column = 
VAR Total_Value = SUM('Table'[Value])
RETURN
IF (
    'Table'[Value] / Total_Value < 0.03,
    "Others",
    'Table'[Category]
)

Result is as below.

Is this the result you expect?
If I've misunderstood you, can you share sample data and the results you are hoping for? Show it as a screenshot or excel. Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sylvine_Wyz]

Hello @v-weiyan1-msft ,

thanks for your return.
You will find below datas exemple : 
First table : 

Date	Order	EAN	quantity
01/01/2023	AB1234	123456789	2
02/01/2023	AB1235	123456789	3
03/05/2023	AB1236	456789132	6
04/05/2023	AB1237	123456789	4
05/07/2023	AB1238	123456789	2
06/07/2023	AB1239	123456789	4
02/01/2024	AB1234	456789132	2
03/01/2024	AB1235	123456789	3
04/04/2024	AB1236	123456789	6
05/04/2024	AB1237	123456789	4
06/08/2024	AB1238	123456789	2
07/08/2024	AB1239	123456789	4
01/01/2023	AB45678	789456123	2
02/01/2023	AB45679	789456123	3
03/05/2023	AB45680	789456123	6
04/05/2023	AB45681	789456123	4
05/07/2023	AB45682	456789132	2
06/07/2023	AB45683	789456123	4
07/07/2023	AB45684	159846237	4

2nd Table : 

EAN	Brand
123456789	Continental
456789132	Goodyear
159846237	Hankook
789456123	Yokohama

In the pie chart, Brand is the category of segment
The user can choice many filters for example : brand, date etc

I hope you can  help me 🙂 

Thanks 

[Sylvine_Wyz]

Hello @amitchandak, 
How are you ? 
do you have a solution for grouping small sectors on pie charts in desktop? like that :

https://learn.microsoft.com/fr-fr/power-bi/paginated-reports/report-design/visualizations/collect-sm...

Thanks for your help 
Have a nice day

[daircom]

Use the below and use cateogry_new as the legend I think. Can you check?

GT = CALCULATE(SUM(table[value]), ALL(table))

% value = CALCULATE( SUM(table[value]) / [GT], ALLEXCEPT(table, table[category]))

Category New = IF([% value] > .03,  table[category], "Others" )

[Sylvine_Wyz]

thanks for your help but "Category new", i must to add this in the new column in the table bi_order ? 
But the result of the line is necessarily smaller than 3 %.
In fact, the table bi_order have many lines