Format all numbers with a thousands seperator by default

michellepace · October 21, 2021, 5:26am

Good morning,

Question: Is there any way I can tell BI to “always” format numbers with a thousands seperator?

I keep having to manually format every measure to use a thousands seperator. I thought by setting my local to English (United Kindgom) as shown would do the trick, but evidentally not.

Melissa · October 21, 2021, 7:09am

Hi @michellepace,

No there’s not but when you have the ability to use Tabular Editor (external tools) you can create and run a scripts, for example.

// Format selected measure(s) as decimal number with thousand separator
foreach(var m in Selected.Measures)
m.FormatString = "#,0.00";

.
@AntrikshSharma has a great course on TE in the learning portal if you want to learn more

I hope this is helpful

michellepace · October 21, 2021, 7:11pm

Thanks @Melissa . @AntrikshSharma could you please share a link for your Tabular Editor ?

BrianJ · October 21, 2021, 7:11pm

@Melissa ,

Thanks - great workaround.

For those interested in implementing this in TE, I’ve posted the script to the Community section of the Analyst Hub using the Raw Code tool.

Brian

Melissa · October 21, 2021, 7:13pm

Here’s a link to that course, hope you’ll enjoy it as much as I did!