Quick Answer
Data formatting changes made from the Underlying Data button in a report's chart view do not save; use the Data tab instead to change and save a column's format, such as converting decimals to percentages.
What This Article Helps With
This article is for Pinnacle Series Administrators who try to change a data column's format in a report - for example, converting decimal scores to percentages - and find the change doesn't save.
Symptoms
When changing the format of a data column from the Underlying Data button in a report's chart view, the formatting toggle does not work or save.
Cause
The formatting options under the Underlying Data button in the chart view are not intended for modifying report formats and do not function correctly for this purpose.
Resolution
To change and save the format of a data column, use the Data tab rather than the chart view's Underlying Data button.
- Open the report.
- Select the Data tab.
- Select the column you want to modify.
- Apply the desired format (for example, changing decimals to percentages).
Confirm the change is saved by reopening the report and checking that the column still shows the new format.