Always format numbers with a thousands seperator

[michellepace]

Hello,

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

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

[v-janeyg-msft · Accepted solution]

Hi, @michellepace 

You can try to change the format in model properties. 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[amitchandak]

@michellepace , I doubt global setting. But in Data model view, you can select more then one column or measure and change it in one go

Check for path

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings