GitHub user dosubot[bot] added a comment to the discussion: Default Chart type on Explore
<!-- Answer --> Yes, you can set Pivot Table as the default visualization type in Explore by updating the `DEFAULT_VIZ_TYPE` setting in your `superset/config.py` file to `'pivot_table_v2'` [reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/config.py#L157-L159). This change is global (not per-user or per-dataset) and will apply to new Explore sessions where no viz type is specified. Steps: 1. Open your `superset/config.py`. 2. Find the line: `DEFAULT_VIZ_TYPE = "table"` 3. Change it to: `DEFAULT_VIZ_TYPE = "pivot_table_v2"` 4. Make sure the Pivot Table plugin is enabled and not denied via `VIZ_TYPE_DENYLIST`. 5. Restart your Superset application for the change to take effect. This will not affect existing saved charts or add table-specific logic (like auto-populating all columns). Only new Explore sessions will default to Pivot Table. <!-- 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/de28776e-aa8a-45e8-9d54-9a4d354dd083?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/de28776e-aa8a-45e8-9d54-9a4d354dd083?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/de28776e-aa8a-45e8-9d54-9a4d354dd083?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/de28776e-aa8a-45e8-9d54-9a4d354dd083?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/de28776e-aa8a-45e8-9d54-9a4d354dd083?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/de28776e-aa8a-45e8-9d54-9a4d354dd083?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/de28776e-aa8a-45e8-9d54-9a4d354dd083?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=Yes%2C%20you%20can%20set%20Pivot%20Table%20as%20the%20default%20visualization%20type%20in%20Explore%20by%20updating%20the%20%60DEFAULT_VIZ_TYPE%60%20setting%20in%20your%20%60superset/config.py%60%20file%20to%20%60%27pivot_table_v2%27%60%C2%A0%5Breference%5D%28https%3A//github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/config.py%23L157-L159%29.%20This%20change%20is%20global%20%28not%20per-user%20or%20per-dataset%29%20and%20will%20apply%20to%20new%20Explore%20sessions%20where%20no%20viz%20type%20is%20specified.%0A%0ASteps%3A%0A1.%20Open%20your%20%60superset/config.py%60.%0A2.%20Find%20the%20line%3A%20%60DEFAULT_VIZ_TYPE%20%3D%20%22table%22%60%0A3.%20Change%20it%20to%3A%20%60DEFAULT_VIZ_TYPE%20%3D%20%22pivot_table_v2%22%60 %0A4.%20Make%20sure%20the%20Pivot%20Table%20plugin%20is%20enabled%20and%20not%20denied%20via%20%60VIZ_TYPE_DENYLIST%60.%0A5.%20Restart%20your%20Superset%20application%20for%20the%20change%20to%20take%20effect.%0A%0AThis%20will%20not%20affect%20existing%20saved%20charts%20or%20add%20table-specific%20logic%20%28like%20auto-populating%20all%20columns%29.%20Only%20new%20Explore%20sessions%20will%20default%20to%20Pivot%20Table.) [](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/36452) GitHub link: https://github.com/apache/superset/discussions/36452#discussioncomment-15193172 ---- 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]
