I believe the only way to dynamically do this is make a Label field. You'd need to then convert each to a string such as:
WHEN [Integer Metric] THEN STR(INT([Metric Value]))
WHEN [Percentage Metric] THEN STR(ROUND([Metric Value]*100,2)) + "%"
then drag this onto the label shelf. I've attached a twbx to demonstrate:
FormatNumbers_10.3.twbx 1.2 MB
thanks Bryce, worst case i can try your trick... BUT, i developed the calculations in another WB and formatted each calculation individually and in that WB it works fine (charts show values formatted exactly how i decided)...
i copied the formulas to a different wb, everything works (change parameter, correct calculated fields populates) EXCEPT the number formats. i can check each individual format and it contains the same as i originally choose, BUT doesnt reflect in this new wb....
i feel some other area is guiding the chart formats.... any thoughts. again ill use your method if i cant figure this out...