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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.