GitHub user dosubot[bot] added a comment to the discussion: Drill by functionality not keeping the selected value
<!-- Answer --> This error happens because Superset requires all column and metric labels in a chart to be unique. If you use "Region" as both the X-Axis and a Dimension, you'll get a duplicate label conflict. To work around this, give one of the "Region" fields a custom label. For example, when adding "Region" under "Dimensions", edit its label to something like "Region (Dim)" or any unique name. This will let you use "Region" in both places without hitting the error. This is a known behaviorāSuperset doesn't enforce label uniqueness automatically, so it's up to you to make sure each label is unique in your chart config. Using custom labels is the standard way to resolve this in complex setups. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/f66a708d-849c-4599-8864-d067caab66cf?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/33718) GitHub link: https://github.com/apache/superset/discussions/33718#discussioncomment-13399459 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
