Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Go for this:
Column =
var num = ROUND(Table[Column],2)
RETURN IF(num > 0, "+"&num&"%", num&"%"
It worked - the plus signs are now here. But the format is different - it's text now, and the percentage signs are missing 😞
Moreover, it added + to negative numbers as well
Yes, unfortunate consequence...
I'd change it to:
Column = "+"&ROUND(Table[Column],2)&"%"
As far as I know that's the only way to get the plus sign in the column, so it'll always be treated like text! I'd just use this as a display column and do all the calculations in the background on another column.
Thank you!
Is there any way not to add plus to negative numbers?
Go for this:
Column =
var num = ROUND(Table[Column],2)
RETURN IF(num > 0, "+"&num&"%", num&"%"
Thank you!!!! You're my saviour! It worked!
Hi,
this solution works fine but if I would like to use conditional formatting it works just for number type 😞
Any other idea?
Many Thanks
D.
Unfortunately as previously stated, since you're adding text characters to the number it'll automatically treat it as text.
The only workaround off the top of my head will be to have a column that jsut returns +/-, then make it so small it's essentially next to the number column. This won't give you conditional formatting for the +/- column however.
Hi, you can actually do this - at least in more recent versions of PowerBI - in a way that still allows for conditional formatting. You need to go to the relationships view, select the field you want to format as a percentage with positive and negative signs, and then in the "properties" pane, choose a custom format and enter "+#%;-#%;0%"
This solution is perfect!
Great solution - thanks!
brillaint!
You can also place the FORMAT() in DAX.
Measure = FORMAT( Table[Column] , "+#%;-#%;0%")
I agree that this is the best answer. However, it will, weirdly, show just "+" or "-" (rather than "-0" or "+0") for values between -0.5 and +0.5 that arent exactly 0, if you want no decimal points.
This solution is great!
However, when I apply it i do not have any decimals. Has anybody an idea how to show decimals?
Thanks!!
Yeah, you can use +0.00%;-0.00%;0.00%
this is the perfect way to do it, thanks!
This is THE Perfect Answer for this case. It doesn't convert the values into string, it still remains numeric even after converting them.
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
60 | |
57 |