Adding fixed text to the end of number and keep number formatting

[OrM]

Hi everyone,

I am trying to add a pp (percentage point) to the end of the number in the measure. But at the same time I don't want power bi to convert it to text. 

I have a measure that returns some number, i.e. 1.56. I have changed it to 1.56 pp by adding text to the end but I would like to have it as a decimal number instead of text. So that I can use it on the bar charts.

Thank you!  

[selimovd · Accepted solution]

Hey @OrM ,

you can do that with the format options.

Like this the number stays the same but when the number is shown it adds the pp.

For that go to the model view in Power BI Desktop and change the formatting of the field:

I think this should solve your problem. 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

[reshmi_nair]

Does this solution work? Adding 0,00 pp. I am trying to do the same to add "%" sign at the end of my calculated measure but doesnt work

[OrM]

Hi @selimovd,

Thaks a lot! Works exactly the way I want.

Regards,

Orkhan 

[reshmi_nair]

Does this solution work? Adding 0,00 pp. I am trying to do the same to add "%" sign at the end of my calculated measure but doesnt work

[selimovd]

Hey @OrM ,

did it work with the format option?

I'm curious if you could solve this issue 🙂

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