Forum Discussion
Number Format
Hi Community,
So this is really basic, but somehow I've not figured it out yet.
I want to present a percentage difference with a +/- prefix while retaining the number functionality (sort by value, conditional formating based on value, mathematical functions).
I've tried:
FORMAT([Policies Sold CYTD]/[Policies Sold PYTD]-1,"+#,##0.0%;-#,##0.0%") but this of course makes it a text field and I lose the functionality I need.
What am I missing here?
Many thanks,
Harry.
Hi Greg_Deckler,
Unfortunately, a percentage value with a +/- prefix is not a supported numeric data type. Currently, you may have to set it to text field. Please submit a feature request at ideas page. Thanks for your feedback.
Regards,
Yuliana Gu
3 Replies
Using the standard Percent format, Modeling tab, Formatting area, Format | Percent, will get you everything except the + sign. Not sure how to do that.
Hi Greg_Deckler,
Unfortunately, a percentage value with a +/- prefix is not a supported numeric data type. Currently, you may have to set it to text field. Please submit a feature request at ideas page. Thanks for your feedback.
Regards,
Yuliana Gu
Thanks for your reply, I've added my vote to the idea here:
Anyone encountering this problem please go there and vote for it. MS are pretty good at listening to the PowerBI community.
