cancel
Showing results for 
Search instead for 
Did you mean: 
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

4 REPLIES 4
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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors