Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In all French speaking organizations and countries, financial numbers are displayed with:
1. A space as the thousands separator
2. A comma as the decimal separator
Furthermore, in Canada, currency is displayed with the currency sign after a space after the number.
If I have 2553128457.75 in my data, I need it to be displayed as 2 553 128 457.75 $
1234.56 should be 1 234,56 $
And since we're on currency, the decimal should be rounded up to two decimal places: 9876.339 should be 9 876,34 $
I have been at this for hours and can't find a solution. What is the custom numeric format that will achieve this?
Solved! Go to Solution.
@splambo Try something like this:
### 000 000.00 \$;(\### 000 000.00 \$);\### 000 000.00 \$
I have similar kind of problem.
In my case-
If I have 2553128457.75 in my data, I need it to be displayed as 2.553.128.457,75 $
Could you please help?
@splambo Try something like this:
### 000 000.00 \$;(\### 000 000.00 \$);\### 000 000.00 \$
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |