GitHub user dosubot[bot] added a comment to the discussion: Pivot Table shows numbers in scientific notation – how to force integer and float format?
<!-- Greeting --> Hi @lwqhp! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> In the legacy Pivot Table, Superset does support per-metric number formatting using `columnFormats` and `currencyFormats`, which lets you set different formats for each metric—like `',d'` for plain integers and `,.2f` for floats with two decimals. However, the UI for the legacy chart does not expose these options directly; you may need to set them in the dataset configuration or via advanced chart settings if available. If a metric has a default format set in the dataset, it can override your custom chart format—removing or adjusting the dataset-level format may help your custom settings take effect in the chart. This approach is confirmed in both the code and user discussions about formatting conflicts and workarounds ([source](https://github.com/apache/superset/discussions/33120), [source](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-pivot-table/src/PivotTableChart.tsx)). So, for your case: set `people_count` to `',d'` and `revenue` to `',.2f'` in the appropriate config (preferably in the chart if possible, otherwise in the dataset), and check for any dataset-level formats that might override your settings. This should prevent scientific notation and adaptive K/M formatting for each metric. <!-- 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/6caf5788-429c-4a3b-b9b3-9cae3f64de25?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/6caf5788-429c-4a3b-b9b3-9cae3f64de25?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/6caf5788-429c-4a3b-b9b3-9cae3f64de25?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/6caf5788-429c-4a3b-b9b3-9cae3f64de25?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/6caf5788-429c-4a3b-b9b3-9cae3f64de25?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/6caf5788-429c-4a3b-b9b3-9cae3f64de25?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/6caf5788-429c-4a3b-b9b3-9cae3f64de25?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-14747149 ---- 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]
