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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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