New measure doesn't look like Whole Number

[Anonymous]

Hi all,

I'm creating a new measure and the type is Whole number.
For Ex measure something like this.

measure = 28174722

When I use this measure on components it looks like text. There is no thousand separator.

Actually this is a whole number and its default behaviour should be like a whole number.
I have to do change the measure one by one each time to show it with thousand separator

Is there any global change for this settings ? I don't want to add separator step by step to my measures. If it is an integer it must be have thousand separator.

[amitchandak · Accepted solution]

@Anonymous , I did not see any setting in options and settings. Ideally, regional setting should help:https://superuser.com/questions/1419853/power-bi-desktop-number-format-shows-american-format-in-visuals-but-european

But in the model view(relationship view), you can select more than one column /measure and change their properties together.

refer only for steps: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[v-shex-msft · Accepted solution]

HI @Anonymous,

AFAIK, current power bi not auto display the thousand separators on number fields. 

For instead, the big numeric values will auto change the display unit to thousand/million based on the thousand places.

Maybe tou can refer to amitchandak 's suggestion to bulk change on table properties or try to submit an idea for improving this scenario.

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , I did not see any setting in options and settings. Ideally, regional setting should help:https://superuser.com/questions/1419853/power-bi-desktop-number-format-shows-american-format-in-visuals-but-european

But in the model view(relationship view), you can select more than one column /measure and change their properties together.

refer only for steps: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings