Add plus sign

Hello tebtim19 ,

You can do as following:
# of Joiner = "+" & CALCULATE (COUNT ([emp ID]),USERELATIONSHIP ( 'SAP'[EntryDate],'Dates'[Date] )

Please let me know if this doesn't help.

Hey tebtim19 ,

if you just want to change the appearance of the value but not the value itself you can also use a custom format that always shows a plus sign when it's positive and a minus when it's negative:

This would display the number like that, but won't change the value itself. So it is still a normal number and not a text:

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi

Hi tebtim19 ,

**EDIT** The below will work, but I believe selimovd has actually provided the best solution.

I would create a new measure as follows:

# of Joiner Plus =
"+" & [# of Joiner]

// or

# of Joiner Plus =
FORMAT(
  [# of Joiner],
  "+0.00"
)

The exact format in the FORMAT() example can be adjusted to how you want it.

The reason I suggest keeping and using your original measure in a reformatted version is because as soon as you make this format change, the measure output becomes text. therefore, you can't use this measure in conditional formatting etc.

Doing it this way means you can use the "Plus" version to actually display in visuals, but you can still use the original version to apply to conditional formatting rules etc.

Pete