Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
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
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
Hey @OrM ,
did it work with the format option?
I'm curious if you could solve this issue 🙂