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!
Is it somehow possible to automatically add a plus sign to the data in a table, which contains both positive and negative numbers, and retain the format (percentage)?
Thanks
Solved! Go to Solution.
Hi @Kate,
You can create a calculated column via this formula:
Col2 = IF(Table1[Col1]>0, "+"&Table1[Col1],FORMAT(Table1[Col1], ""))
Regards,
Yuliana Gu
Hi @Kate,
It is not possible to add a plus sign to positive numbers. If you add such a plus sign, the data type of field will be converted to Text rather than numeric.
Regards,
Yuliana Gu
Hi,
any good ideas how to have this. I my case, with out the + sign, the figures look like % of of instead of % growth when shown with the + sign before
Sven
Thank you! I just wanted to make such a column for my visualization, in which the type of data wouldn't matter.
Hi @Kate,
You can create a calculated column via this formula:
Col2 = IF(Table1[Col1]>0, "+"&Table1[Col1],FORMAT(Table1[Col1], ""))
Regards,
Yuliana Gu
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |