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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
How do I find a way to format the resulting percentage in the bar graph from the measures used below as "0.00%"? I can neither use the &"%" at the end of the measure nor use the FORMAT() function in the measure. Is there a way to do it?
Percent Complete = (SUM('FTE - Main Data'[Completed]) / ( SUM('FTE - Main Data'[Completed]) + SUM('FTE - Main Data'[Not Completed]) ) )*100
Percent InComplete = ( SUM('FTE - Main Data'[Not Completed]) / ( SUM('FTE - Main Data'[Completed]) + SUM('FTE - Main Data'[Not Completed]) ) ) * 100
Bar graph fields:
Solved! Go to Solution.
Found out that I needed to change the Format under the 'Measure tools' menu bar option and it worked as intended:
Found out that I needed to change the Format under the 'Measure tools' menu bar option and it worked as intended:
Hello,
I'm not sure why you are not able to display the values as percent. However, you can consider rewriting your measure where, your formulas are a variable and you return them with a FORMAT (_Variable,"0.00%")
Lastly, try using the Data Labels and turning it on, and using a corresponding measure to help display these labels. Hope this helps!
Proud to be a Super User! | |
The values you see in the graph are the Data Labels which are reflecting accurate percentages but are not including the '%' character at the end.
I tried your first suggestion and it does not seem to work properly either as it breaks the visual.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.