GitHub user dosubot[bot] added a comment to the discussion: Filter values should be list of given values not automatically fetched from data
<!-- Answer --> Superset dashboards do not natively support configuring filter dropdowns to display a static or predefined list of values; filter values are always fetched dynamically from the dataset columns they are mapped to. This is a known limitation and there is an open feature request to allow manual configuration of filter values for dashboard filters, but it is not yet implemented ([discussion](https://github.com/apache/superset/discussions/34841), [discussion](https://github.com/apache/superset/discussions/35171)). The SelectFilter component used in ListView pages (not dashboards) does support static lists, but this capability is not available for dashboard filters without custom development ([code reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/components/ListView/Filters/Select.tsx#L44-L135)). Workarounds include creating a reference/static table in your database with all possible values, or developing a custom filter plugin, but there is no built-in UI or configuration for static filter lists in dashboards as of now. <!-- 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/3ea14aef-2abe-4662-9309-d399d9c71630?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/3ea14aef-2abe-4662-9309-d399d9c71630?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/3ea14aef-2abe-4662-9309-d399d9c71630?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/3ea14aef-2abe-4662-9309-d399d9c71630?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/3ea14aef-2abe-4662-9309-d399d9c71630?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/3ea14aef-2abe-4662-9309-d399d9c71630?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/3ea14aef-2abe-4662-9309-d399d9c71630?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=Superset%20dashboards%20do%20not%20natively%20support%20configuring%20filter%20dropdowns%20to%20display%20a%20static%20or%20predefined%20list%20of%20values%3B%20filter%20values%20are%20always%20fetched%20dynamically%20from%20the%20dataset%20columns%20they%20are%20mapped%20to.%20This%20is%20a%20known%20limitation%20and%20there%20is%20an%20open%20feature%20request%20to%20allow%20manual%20configuration%20of%20filter%20values%20for%20dashboard%20filters%2C%20but%20it%20is%20not%20yet%20implemented%20%28%5Bdiscussion%5D%28https%3A//github.com/apache/superset/discussions/34841%29%2C%20%5Bdiscussion%5D%28https%3A//github.com/apache/superset/discussions/35171%29%29.%0A%0AThe%20SelectFilter%20component%20used%20in%20ListView%20pages%20%28not%20dashboards%29%20 does%20support%20static%20lists%2C%20but%20this%20capability%20is%20not%20available%20for%20dashboard%20filters%20without%20custom%20development%20%28%5Bcode%20reference%5D%28https%3A//github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/components/ListView/Filters/Select.tsx%23L44-L135%29%29.%20Workarounds%20include%20creating%20a%20reference/static%20table%20in%20your%20database%20with%20all%20possible%20values%2C%20or%20developing%20a%20custom%20filter%20plugin%2C%20but%20there%20is%20no%20built-in%20UI%20or%20configuration%20for%20static%20filter%20lists%20in%20dashboards%20as%20of%20now.) [](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/37835) GitHub link: https://github.com/apache/superset/discussions/37835#discussioncomment-15754001 ---- 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]
