Formatting of 15% as +15%

ells · March 22, 2021, 10:33am

Had a weird ask today. When I show 15% growth can it be displayed as +15%

Can this be done without turning the measure to a text value?

Thanks
E

Greg · March 22, 2021, 10:49am

Hi @ells. Not AFAIK.
Greg

Rajesh · March 22, 2021, 10:54am

Try this format

Rajesh · March 22, 2021, 11:10am

You can use below format for +ve and -ve

Greg · March 22, 2021, 12:04pm

Who knew?

BrianJ · March 22, 2021, 12:14pm

Not me, either. Nice one, @Rajesh!

— Brian

Rajesh · March 22, 2021, 1:15pm

DavieJoe · March 22, 2021, 1:24pm

Gonna file this nugget away!

ells · March 22, 2021, 2:29pm

Thanks,
Awesome.
E

ells · March 23, 2021, 9:28am

to add value (not a lot)
I ended up with -#0.#%;+#0.#%

You know how it is suddenly you find one of the values is 0.2% and shows as +.2% so quick tweak.

Many Thanks
E