Category
Report Builder
Product Version
7.3
Axis tick numbers not formatted
Resolved
I have some scatter charts where my Y-axis corresponds with a percentage column. Chart looks great except that the numbers on my chart-axis are showing decimal values (e.g. .01) and not the % format I specified on my column (e.g. 10%). The chart's data table is formatted correctly to show the same column with the format I desire. How can I change my axis to display the same number format as my corresponding data column?
The same problem 
Hi Kevin,
It sounds like you are using the percentage formatter at the report level, which is then not applied at the chart level?
I would recommend instead creating a calculated field to multiply this value * 100 and add the "%" prefix in the chart formatting menu. Generally report formatters will only apply to certain areas in the chart builder as they are a post processing effect that essentially converts this field into a string which in turn cannot be used for functions that require numeric fields such as a charts axis.
Let me know if this makes sense.
Regards,
Nathan
Hi Kevin,
It sounds like you are using the percentage formatter at the report level, which is then not applied at the chart level?
I would recommend instead creating a calculated field to multiply this value * 100 and add the "%" prefix in the chart formatting menu. Generally report formatters will only apply to certain areas in the chart builder as they are a post processing effect that essentially converts this field into a string which in turn cannot be used for functions that require numeric fields such as a charts axis.
Let me know if this makes sense.
Regards,
Nathan
Replies have been locked on this page!