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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ShootingBlanks
New Member

Group column values, get a total/count of each one, then visualize in a pie chart

Hello.  I'm new to Power BI, so this may be a basic question (although I have googled around and checked the forum before making this post)...

 

I have a column of data with four values - let's call them V1, V2, V3, and V4.  So, the column may look like:

V1

V4

V2

V1

V2

V3

V1

V1

 

I just want to get the percentage of the appearance of each of those put into a pie chart.  So, in the example above, there would be a pie chart with V1 taking up 50% (4/8 entries), V2 taking up 25% (2/8 entries), and V3/V4 taking up 12.5% each (1/8 entries each).

 

I've only used the WYSIWYG interface of Power BI and haven't messed with scripting yet, but I do have a programming background, so if that is what this solution involves, that should be fine.  Thanks!

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@ShootingBlanks

 

Hi my friend. 

 

Please follow the steps showed in the below image.

 

Pie.gif

 

Victor Velarde

Lima-Peru




Lima - Peru

View solution in original post

3 REPLIES 3
MFelix
Super User
Super User

Hi @ShootingBlanks,

If you want this in a PieChart just add the column with the V1, V2 and so on to the values of the pie chart and choose option count and also add that column to the legend and that will give the expect result and then.in the options you can choose if.you show values percents in the labels.

Regards,MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Vvelarde
Community Champion
Community Champion

@ShootingBlanks

 

Hi my friend. 

 

Please follow the steps showed in the below image.

 

Pie.gif

 

Victor Velarde

Lima-Peru




Lima - Peru

@Vvelarde

 

Thank you for probably the quickest and most comprehensive/visual/easy-to-understand accurate response I've ever received on a support forum...very much appreciated! Smiley Very Happy

Helpful resources

Announcements
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.

Top Solution Authors