3 Replies Latest reply on May 9, 2018 4:16 AM by pavan kumar

Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

Jeremy Calloud May 9, 2018 2:16 AM

The official formatting in my company is to use a small 'k' and 'm' to display Thousands or Millions units.

Is there a way to update the default units associated with Thousands, Millions, ... o, in below screen?

I know it can be done with custom formatting or calculated field but I am looking at updating my full portfolio of workbook, so this isn't an option given the number of fields and sheets associated.

Thanks

1. Re: Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

Sankarmagesh Rajan May 9, 2018 3:03 AM (in response to Jeremy Calloud)

Hi Select custom and change to m or k

Thanks
sankar
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

Jeremy Calloud May 9, 2018 3:31 AM (in response to Sankarmagesh Rajan)

Yes indeed, but that would mean go and manually update all my fields, which is why I asked if this there is a solution without Custom Formatting.

I was hoping that I could change the unit symbol in Tableau preferences so that all fields using Millions units will switch to the new symbol: 'm'.
Like Show 0 Likes(0)

Actions
3. Re: Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

pavan kumar May 9, 2018 4:16 AM (in response to Jeremy Calloud)

Hi,

Have you tried the default properties for the measure. I think if you change for the object itself then it might reflect in all places.

Regards,
Pavan
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

1. Re: Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

2. Re: Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

3. Re: Change default units formatting to non-capital letters without custom formatting (e.g. K to k and M to m)

Actions

More Like This