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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.