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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors