Dynamic Number and Currency Formatting

Feature Suggestions
1

Hello folks,

I’d like to propose a feature enhancement for number and currency formatting. Currently, we can format numbers with abbreviations like “k” for thousands and “M” for millions, but it’s not dynamic. It would be great to have an automatic formatting option that works as follows:

  • For numbers < 1000, display the full number.
  • For numbers ≥ 1000 and < 1,000,000, display with “k” (e.g., 4,500 → 4.5k).
  • For numbers ≥ 1,000,000, display with “M” (e.g., 2,500,000 → 2.5M).

This dynamic formatting would improve readability and consistency across different data scales. I haven’t seen this feature in the current application, and I believe it would be a valuable addition.

Thanks for considering this request.

2

Hi @MaximeBessou

Thank you for your suggestion! We totally agree with you and have added your request to our backlog for future improvements.

Thanks,
Phuong.

3

Hi @MaximeBessou,
Great news, the Auto number abbreviation feature you suggested is now live! :tada:

You can now set abbreviation to Auto in your number format settings. Holistics will dynamically assign the right unit (800, 4.5K, 2.5M, 1.2B) based on each value’s size in the exact same column.

Check out our community post here for more details: [Launched] Auto-abbreviate numbers to K / M / B :1234: - Product Releases - Holistics Community

Thanks for helping us improve Holistics!