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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a Column with "Percentage" and I want to show the Average of this Column over the 100%.
On the next example I would want to see 2 parts (37,50% and 62,50%):
I tried to add another value (Max of this "Percentage Column") but it's not exactly what I want because it shows like that:
As u can see an Average of 49,95 represents a 33,31%.
And in this case it should represent 49,95 over the 100% and the other part of the circle has to represent the 50,05.
Assume you have measure
Percentage
Then create one more measure and use both of them in pie
calculate([Percentage], all()) - [Percentage]
or
100 -[Percentage]
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.