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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors