Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Budget Remaining in Pie Chart

Hi Everyone, 


So this seems like such a simple problem that I am wracking my brain on how to fix. I have a spreadsheet with contract values by unit within my company. In a separate, but linked/related spreadsheet I have annual budgets for each unit within my company. 


I'm trying to create a pie chart that shows Unit A's contract values as a percent of Unit A's overall budget. I've created a measure that gives me this info. For instance, I know that Unti A's contracts total 64% of Unit A's overall budget, and as an example Contract 100 = 16% of the overall budget. 


But how can I show this in a pie? Since the total contract values do not add up to 100% of the budget. I need to somehow show the 36% not spent/remaining. But I can't figure out how. 


Suggestions? Thanks for your help!


Hi @spencer_g,

You can also use the DialGuage custom visual to show your values.


Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Champion
Community Champion

hi @spencer_g


You can use a Gauge Visual to show this.


Visual Gauge with Value and TargetVisual Gauge with Value and Target

Lima - Peru

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors