Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 56 | |
| 33 | |
| 32 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 65 | |
| 64 | |
| 44 | |
| 30 | |
| 28 |