Native dashboard filter to select which metric a chart displays

What is the problem or goal you're trying to solve or accomplish?

The customer builds many charts that share the same datasource and configuration but differ only in the metric (or dimensional breakdown) being shown. They want a way to set up a chart or dashboard where the viewer can select which metric they want to view, rather than maintaining a separate chart for each metric. Today there's no native option for this: dashboard filters act on dimension (column) values, not on metric selection.

How are you solving it currently?

They're considering (or using) workarounds, each with downsides:

• Unpivoting the data to metric_name / metric_value columns and filtering on metric_name — requires restructuring the underlying data and forces all metric values onto one axis regardless of unit.

• Jinja-templated dataset metrics that switch on filter_values() — works, but adds maintenance overhead and makes caching filter-dependent.

• Duplicating charts (one per metric, or per dashboard tab) — multiplies chart count and dashboard load time.

What is your recommended solution?

A native filter type — analogous to the existing Value filter — that targets a chart's metric instead of a column. The viewer would pick from a configurable list of dataset metrics via a dropdown, and the scoped chart(s) would re-render using the selected metric. Ideally supports single/multi-select and respects filter scoping. (The customer noted this isn't blocking — they're fine closing the ticket — but would welcome it as a future development.)