Default Chart type on Explore

[keanec27]

@dosu Can I set Pivot Table as the default visualization type when exploring a dataset, instead of the regular Table?

[dosubot[bot]]

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. 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.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

   

[keanec27]

@dosu is there a way to change the default value format ?

[dosubot[bot]]

Yes, you can change the default value format for Pivot Table (and other charts) in Superset, but it requires editing the chart plugin's control panel configuration in the codebase.

For Pivot Table, the "Value format" control uses the shared y_axis_format setting, which defaults to a centralized number format. To change the default, update the default value for y_axis_format in the shared controls file (reference), or directly in the Pivot Table control panel (reference). You can set formats like ,.2f for two decimals, % for percentage, etc.

For global number formatting (affecting all charts), you can set the D3_FORMAT dictionary in your superset_config.py file. This changes how numbers are displayed in the UI, but does not affect CSV/Excel exports (reference).

If you need to customize currency or date formats, there are also currency_format and date_format controls available in the Pivot Table options.

Let me know if you want step-by-step instructions for editing these files!

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}