Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I tried using regional setting but i didn't worked, my expectation is to change 123,456 to 123 456. Here comma seperator is replaced by space. Can someone suggest how it can be done?
For currency, try this:
Credit to @Greg_Deckler for providing the solution ### 000 000.00 \$
See the original answer: https://community.powerbi.com/t5/Desktop/How-to-format-data-numbers-to-Canadian-French-currency-form...
If you don't want the zeros to appear after the decimal, use ### 000 000.## \$
If you are looking to display data in your report in the French format (good for all places where French is an offical language, not just France ;), the following formatting code will output 687532 as 687 532. This code works all the way up to billions.
# ### ### ##0, $
-Select your column in the Data panel
-Column Tools tab
-Format field in the top ribbon
Thanks to Hein Kruger on https://community.dynamics.com/business/f/dynamics-365-business-central-forum/476492/ssrs-report-cha...
Hi @Anonymous ,
You may try to use change type with local. Please refer to https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can try the following measure (caveat, the value is converted to text, so should only be used as the final display)
Separator =
VAR Leng =
LEN ( [Sum Value] )
VAR Thous =
LEFT ( [Sum Value], Leng - 3 )
VAR Rest =
RIGHT ( [Sum Value], 3 )
RETURN
IF ( [Sum Value] >= 1000, Thous & " " & Rest, Rest )
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |