I'm having an issue where my custom formatting is lost when I get new data.
I have a SQL datasource that is formatted to the template and a couple stored procedures that pull in new data daily.
I have 12 KPIs on a page and half have custom formatting other than a 1 decimal percentage, but when the new data comes all formatting is reverted back to a 1 decimal percentage. I do have a column stored where I could drop in the type of formatting I want, but that doesn't appear to be an option.
This has been happening for a while and everytime Management wants to view the report I need to manually change the formatting back.