Number Format

[Ruksuro]

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.

[v-yulgu-msft · Accepted solution]

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

[Ruksuro]

Thanks for your reply, I've added my vote to the idea here:

 https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18003598-number-formatting#commen...

Anyone encountering this problem please go there and vote for it. MS are pretty good at listening to the PowerBI community.

[Greg_Deckler]

Using the standard Percent format, Modeling tab, Formatting area, Format | Percent, will get you everything except the + sign. Not sure how to do that.