Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am using this format to have parentheses in my decimal number data type. Is it possible to add in a comma to this format?
Its currently greyed out.
0.;(0.);
Thank you
Solved! Go to Solution.
Hi @aishak12 ,
According to your description, I create some data:
Here are the steps you can follow:
1. Create calculated column.
Column =
"("&FORMAT(ABS('Table'[sqlimport]),"#,##0")&")"
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
have you tried to change your regional settings
and then if you dont customize the format you should be able to add the thousand separator which I am assuming you are trying to do.
Proud to be a Super User!
Hey @aishak12 ,
if you use manual formatting options you cannot add the standard ones. They are grayed out as you already realized.
Sorry, I didn't full understand how the result should look like. Can give me an example how the result should look like, then I can give you a proposal.
Thank you for your help!
The number in SQL is imported as
-2130
I would like the number in my table matrix to populate as
(2,130)
Is this possible
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |