Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to Solution.
Hi my friend.
Please follow the steps showed in the below image.
Victor Velarde
Lima-Peru
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi my friend.
Please follow the steps showed in the below image.
Victor Velarde
Lima-Peru
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! ![]()
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!