GitHub user dosubot[bot] added a comment to the discussion: Pivot Table shows numbers in scientific notation – how to force integer and float format?
<!-- Answer --> In Superset 6.0.0-rc2, the legacy Pivot Table chart does not support per-metric (per-column) number formatting through the UI. The "Value format" and "Currency format" options in the Customize tab apply globally to all metrics, and there is no "Advanced chart settings" button or feature-flag that enables more granular formatting for individual metrics. Unlike the Table chart, the Pivot Table does not have a "Customize columns" panel for per-column formatting. While the chart component itself supports per-metric formatting via `columnFormats` and `currencyFormats` props, these are not exposed in the UI and must be set programmatically or via dataset metadata if available ([source](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-pivot-table/src/PivotTableChart.tsx), [control panel config](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-pivot-table/src/plugin/controlPanel.tsx)). <!-- 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/a20b19d0-bd41-4546-82d0-3310db9a243a?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/a20b19d0-bd41-4546-82d0-3310db9a243a?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/a20b19d0-bd41-4546-82d0-3310db9a243a?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/a20b19d0-bd41-4546-82d0-3310db9a243a?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/a20b19d0-bd41-4546-82d0-3310db9a243a?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/a20b19d0-bd41-4546-82d0-3310db9a243a?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/a20b19d0-bd41-4546-82d0-3310db9a243a?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](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/35781) GitHub link: https://github.com/apache/superset/discussions/35781#discussioncomment-14748225 ---- 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]
