Hello ,
Please i need to know how to add % sign to my measure result.
thanks for your help
Best regarders
Solved! Go to Solution.
As @lalthan said, you just need to click the Percenage Format under Modeling.
It can be applied on your custom measure as well.
There are two ways to achieve this:
1. On PBI Desktop, click on your measure and formula will appear > Go to Modelling > Format as %
or
2. Create a measure as : format([Measure Name],"percent")
However, if you use the 2nd approach, then your measure will be treated as text
HI @lalthan
Thanks for your answer i know how to calculate percentage on power BI
but my problem that i need to create a measure with my personal calculation rule , for example my measure [Measure]= ([Nombre_IC_S12]/([Nombre_Facturé_S12]+[Nombre_IC_S12]))*100
and i need to show in the display % symbol
I need to show the result with % symbol ...
Best regards
if you do the formula with the "*100" it will give the correct Percentage without the Symbol, Try the formula without the *100 this will give you a "0." Value you can then change the format mentioned above in the ribon this will give you the Percentage along with the Symbol. @lalthan with his formula using the method you mention before removing the the "*100" from the formula will results in 1000% increase in the percentage since his formula already is doing the work and is a above 1.0 (ex 39% will become 3900%)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
195 | |
70 | |
67 | |
55 | |
51 |
User | Count |
---|---|
252 | |
216 | |
102 | |
80 | |
71 |