Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
chillpill
Helper I
Helper I

Formatting a value as a percentage on a bar graph when measure result is a whole number

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

 

chillpill_0-1719504915620.png

Bar graph fields:

 

chillpill_1-1719504995828.png

 

1 ACCEPTED SOLUTION
chillpill
Helper I
Helper I

Found out that I needed to change the Format under the 'Measure tools' menu bar option and it worked as intended:

 

chillpill_0-1719515089467.png

 

View solution in original post

3 REPLIES 3
chillpill
Helper I
Helper I

Found out that I needed to change the Format under the 'Measure tools' menu bar option and it worked as intended:

 

chillpill_0-1719515089467.png

 

ExcelMonke
Super User
Super User

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! 





Did I answer your question? Mark my post as a solution!

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.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors