Cross-posting this issue into the QuickSight community:
As of this writing, applying a background color using a gradient through conditional formatting of a numeric (DECIMAL or INTEGER) column in a Table visual causes the table to render with the message:
The data type of a field used in this visual has changed too much for QuickSight to automatically update your analysis. You can adjust field data types by editing or replacing the current dataset.
This is a new issue that has appeared in recent days and is affecting a QuickSight dashboard that was published months ago and used heavily just last month.
As a workaround, I’ve removed conditional formatting from all columns in the table, and the table is now successfully rendering.
Here is an example using a subset of the data in a new analysis:
This table experiences the issue once a gradient is applied to either of the columns.
(As a new user, I’m apparently not permitted to upload the second image in this post.)