rad-pat opened a new issue, #29227: URL: https://github.com/apache/superset/issues/29227
### Bug description Swapping the dataset of a chart using the numeric metric of the original dataset to another dataset that has a numeric metric of the same name fails converts the metric datatype to text and loses the custom formatting. ### How to reproduce the bug Create dataset 1 with numeric metric "Metric1", sum(some numeric column), apply D3 formatting `$,.2f` Create dataset 2 with the same metric name and formatting. Create table chart1 from dataset1 add columns and metric1 Create chart and see formatting on metric column Save Chart Edit Chart Swap dataset to dataset2 Click continue on Continue on message about controls will be retained. View "Customize" tab, metric appears to be numeric Click "Update Chart" - metric now switches to text and formatting is lost. ### Screenshots/recordings _No response_ ### Superset version 3.1.3 ### Python version 3.10 ### Node version I don't know ### Browser Chrome ### Additional context _No response_ ### Checklist - [X] I have searched Superset docs and Slack and didn't find a solution to my problem. - [X] I have searched the GitHub issue tracker and didn't find a similar bug report. - [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org