Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

A + denoting a positive trend in visualisation

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...
  • speedramps's avatar
    2 years ago

    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.