Group Smaller Slices with condition in Pie Charts

[AlbLS]

Hi everybody,

I have a problem that I can not fix, I hope your help can save me!

I would like to group the small slices of a pie chart with one condition, when the percentage of total is less than 5%.

I know the option to create a group by categories in the pie chart but this option does not work because the group always contains the same categories.

Here I found an example for SQL Server, but not for POWER BI:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/collect-small-slices-on-a-pie-... server-2017

I leave you my Power BI file here:

https://drive.google.com/open?id=1wrs1uh9u8SUOUISg1hvFGqTB_IRUbLtA

I thank you in advance!!

Best regards

Alberto