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