Compact number formatting option for tables (at least)

[mheftisw]

What problem will this feature request solve?
On trend and number visualizations, when the number is just too big the format of the number is automatically adjusted which is very convenient (even if more configuration options would be nice)
For example: 23 345 000 becomes 23,3 M.
On table visualization, we do not have this option and the only get-around, we found was to do it on SQL:
CASE
WHEN value > 10000000 THEN round(value / 1000000 ,1) ||" M" ...

But we have M, K values in the table then sorting does not work.

• We created a hidden KPI to have the right sorting by default, but if the users play with the sorting option (which is also intended), it's definitly not working
• We also tried to add parameter but it adds complexity when metabase offers a nice sorting option natively.

Describe the solution you'd like.
Have to possiblity to configure the compact option for numbers on table visualization.

How does this feature request impact you?
Improve UX/UI of the dashboards to our external users.

[alexyarosh]

@mheftisw thank you for the feature request! I think it makes sense to have the option compact formatting for tables. We'll review this internally.

In the meantime, you should be able to accomplish the similar results as your SQL query with purely table visualization settings (so it won't affect sorting). Unfortunately this will only work if you have e.g. always millions, but not a conditional million/thousand etc:

[mheftisw]

Thank you. I tried this solution but depending on the selected perimeter or granularity we might have:

• 986 and 12 000 at the same time ; or
• 986 000 and 12 000 000 at the same time and so on

Besides this dashboard is deployed automatically to customers using several currencies (some with very high figures).
Therefore this solution is not adapted unfortunately.