Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
leekarensl
Frequent Visitor

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 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!

Screenshot 2024-02-01 142923.png

1 ACCEPTED SOLUTION
speedramps
Super User
Super User

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%

speedramps_0-1706802113073.png

 

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.

View solution in original post

2 REPLIES 2
leekarensl
Frequent Visitor

@speedramps , thank you, your solution works perfectly!

speedramps
Super User
Super User

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%

speedramps_0-1706802113073.png

 

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.