Skip to main content
cancel
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.

Reply
mellas_k
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 

 

1 ACCEPTED SOLUTION

@mellas_k

 

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

 

6.PNG

 

It can be applied on your custom measure as well.

 

 

 

View solution in original post

5 REPLIES 5
perfectreign
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.

 

modeling.png

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

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 

@mellas_k

 

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

 

6.PNG

 

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

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

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.