Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |