A + denoting a positive trend in visualisation

[leekarensl]

Hi all,

One of my visualisations that I created for my stakeholders is one indicating the YoY percentages. If you see the screenshot below, you can see that spend is in the negative when compared to last year but impressions is up. My stakeholder is asking me if it is possible to have a plus sign for the impressions. In other words it will show +2.31%. Is this possible? How do I do that? Thanks!

[leekarensl]

@speedramps , thank you, your solution works perfectly!

[speedramps · Accepted solution]

Try this method ....

Click on the Modelling view icon.

Click on your measure name.

In the Propertise window select Formating, Format = Custom

• Then set the custom fomat to +0.00%;-0.00%

Or you can create a measure

measurename = 
FORMAT(
[Impression],
"0.00%;-0.00%"
)

Thanks for the clear description of the problem with example data. I wish everyone did that!

Remember we are unpaid volunteers, and you have got free expert help which took a lot of effort,
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos. 

One question per ticket please. If you need to change or extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

Please now click the [accept as solution] and the thumbs up button.  Thank you.