Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hello,
I have 12 departments, and I want to visualize their percentages using a pie chart in Power BI. However, with this many slices, the percentages become difficult to read. Is there a way to resize or adjust the slices to ensure that all percentages are displayed clearly,
I prefer to stick with the pie chart for this visualization. Any tips would be greatly appreciated!
Thank you !
Solved! Go to Solution.
With that much category, a pie chart isn't really a good idea. I would use a table with gradient/data bars formatting on the values or a column/bar chart.
Use a calculated column or measure to group smaller slices into an "Others" category:
Grouped Department =
IF(
[Percentage] < 5,
"Others",
'Departments'[Department]
)
While still a circular chart, a doughnut chart offers better visual balance for a high number of slices.
💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
With that much category, a pie chart isn't really a good idea. I would use a table with gradient/data bars formatting on the values or a column/bar chart.
Hello @Lolo_2023 ,
You try the below label customization.
Also you try to increase the size of the visual this will not clutter the labels.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
@Lolo_2023 , Increase the size of the pie chart so more numbers will be visible. Else "Show as Table" option would also work.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 21 | |
| 20 | |
| 14 |
| User | Count |
|---|---|
| 59 | |
| 52 | |
| 41 | |
| 33 | |
| 32 |