Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Changing data labels to percentages in pie charts

I am sure this has been asked an answered several times, but I dont have a clear cut answer without creating another calculated measure or column.  Here I have a simple display showing the number (count) of males/females/other served in a given Fiscal Year (a slicer).  The data labels properly display the count and when I hover it does show the percentage.  Is there a way to get THAT percentage to display instead of the actual count?

 

Thanks for the information.fy sex count.jpg

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@Anonymous

 

You can using QuickCalc of your Column.

 

Click on your column in values and select Quick Calc

 

Q%.png




Lima - Peru

View solution in original post

4 REPLIES 4
Vvelarde
Community Champion
Community Champion

@Anonymous

 

You can using QuickCalc of your Column.

 

Click on your column in values and select Quick Calc

 

Q%.png




Lima - Peru

I have tried this, but all my percentages show as 100% which obviously isn't right. I am sure I must be doing something wrong, but not sure what!

 

Jeff

Anonymous
Not applicable

Gracias!  This is exactly what I needed and yes, it worked.

Sean
Community Champion
Community Champion

@Anonymous  Try the Sunburst Custom Visual (its a Microsoft Visual)

 

Then you won't have to create a Measure (its a bit... tricky to use and not very customizable...)

 

But here's the result

 

Sunburst.png

 

Also give the Donut Chart a try - but you'll need a Measure there however it is more customizable!

 

Good Luck! Smiley Happy

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.