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

Adding string literal to a measure on line chart

Hi,

I have a line chart that looks like this.

Percent.PNG

I want to append the string literal '%' to all the values on the line chart. Ex: -153.96 must become -153.96%. 44.2 must become 44.2%.

The values are coming from a measure as seen below

Percent Measure.PNG

How can I make this happen?

Thanks!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I figured it out.

Percent Answer.PNG

View solution in original post

4 Replies
vvira1316
Specialist II
Specialist II

Hi,

Have you tried following

Number formatting and selecting %

Percentage.JPG

Anonymous
Not applicable
Author

I figured it out.

Percent Answer.PNG

aarkay29
Specialist
Specialist

you can use either custom formatting by simply adding '%' at the end or

change the exp to  num(netmargin/100,'##.#0%')

Anonymous
Not applicable
Author

This does not work. When I do this, the value is getting displayed as 15396.00% instead of 153.96%.