The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
41 |