Budget Remaining in Pie Chart

[spencer_g]

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!

[v-yuezhe-msft]

Hi @spencer_g,

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




Thanks,
Lydia Zhang

[Vvelarde]

hi @spencer_g

You can use a Gauge Visual to show this.

Visual Gauge with Value and Target