Allow per-chart color overrides for identical metric names in dashboards

What is the problem or goal the end user is trying to solve or accomplish?

The customer is building multiple charts that use the same metric (e.g., P-Value) but want each chart to display that metric using a different color, depending on the context (e.g., “positive” vs. “negative” statistical outcomes). This visual distinction is critical to convey meaning across a large set of charts and dashboards.

How are they solving it currently?

Currently, the only workaround is to create multiple duplicate metrics at the dataset level with the exact same SQL logic but different names (e.g., P-Value_Pos, P-Value_Neg) and assign each to a different chart. This is not scalable, especially when the same logic is reused in 15+ charts. Renaming metrics in the chart-level label override does not work, as the dashboard applies colors based on the internal metric key.

What is the recommended solution by the Customer?

Allow users to override chart-level color assignments for metrics, even when the metric name is the same across multiple charts in a dashboard. Ideally, this could be done through:

• Chart-level color assignment per metric instance, or

• Respecting local palette overrides at the chart level that supersede global color bindings.