Hi there. When Metabase is abbreviating a number (eg: 5,000) and I shrink the question display field in a dashboard it abbreviates (ex: 5K). For instance, I want to change the K letter to other abbreviation (eg: 5 mil).
Is there a way to change this?
Hi @coutoreis
That’s currently not possible for the automatic abbreviation. And 5 mil
is almost the size of 5,000
.
You can manually modify it with formatting, by dividing with 1000 and adding suffix " mil".
What language do you speak, since you don’t like the K
?
I speak Portuguese. The K sounded strange to the end user, so that he asked if it’s possible to change it.
The division by 1000 and adding the " mil" suffix is the workaround I’ve done.
Thanks for the reply, @flamber!
@coutoreis
The goal was to keep it as short as possible - otherwise the format compacting wouldn’t make sense - and also international.
And since kilo
is used in most of the world, then that’s a good indicator.
But I can understand the visual problem from the user - it took a few seconds for me to understand what was going on, when I saw Metabase’s way for compacting numbers the first time.
1 Like