Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to format numbers with space as thousand-separator and a comma as decimal-separator. Im very close but cant seem to get it working all the way:
Hi @Anonymous,
Power bi desktop uses the number format as your system region and currency symbols settings.
You can refer to amitchandak's links to modify them in your system settings but they will also affect the general numeric values stored in your system.
For format function, it will convert your number to text and display it with the specific format that you defined in the optional parameters.
I'd like to suggest you try to do formatting in your table field properties, it only changes the display value format and not affect the raw record values:
Use custom format strings in Power BI Desktop
Regards,
Xiaoxin Sheng
@Anonymous , you have to do regional setting
https://community.powerbi.com/t5/Desktop/Always-use-the-default-regional-settings/td-p/79108
https://audministrator.wordpress.com/2017/10/31/powerbi-number-and-currency-formatting/
@Anonymous
Is this what you want?
Column = FORMAT('Table'[Column1]/1000,"# ### ###.##")
Proud to be a Super User!
User | Count |
---|---|
122 | |
109 | |
97 | |
60 | |
57 |
User | Count |
---|---|
137 | |
114 | |
102 | |
70 | |
56 |