Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
92 | |
82 | |
63 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |