Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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
@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