Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I
Helper I

how to add % sign to my mesure result

Hello , 


Please i need to know how to add % sign to my measure result.

thanks for your help 

Best regarders 





As @lalthan said, you just need to click the Percenage Format under Modeling.




It can be applied on your custom measure as well.




View solution in original post

Frequent Visitor

Hi, I'm answering an old post in hopes of getting my answer. 


I have a table report. I want to conditional format one column based on the value. As such, I have a number pulling in from the SQL query.  I do, however, want to add a percent sign to the column.  I cannot see the Data Type section under the Modeling tab.  Did it move?


Here's my report and PowerBI menu.



Resolver II
Resolver II

There are two ways to achieve this:


1. On PBI Desktop, click on your measure and formula will appear > Go to Modelling > Format as %


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 



As @lalthan said, you just need to click the Percenage Format under Modeling.




It can be applied on your custom measure as well.




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%)

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.