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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Add % symbol to values

I have a column of values such as 0.00, 20.60, 100, 53.48. I want to change the formatting of the values so that they are 0.00%, 20.60%, 100%, 53.48%.

 

However, when I try to convert to a percentage the values are always converted into: 0%, 2060%, 10000%, 5348%. I have tried to convert to a percentage format within the field properties, the modeling tab, and in the query editor with no luck. It will always convert into a percentage in the thousands.

 

How can I add the % to a column of values that are already a percentage?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi

 

It may be that the simpilest answer to this, is to create a custom column, dividing the column you with to convert to a percentage by 100 and then formatting that as a percentage.

 

You can then hide the original column in your model so that it isnt used by accident.

 

Thanks

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi

 

It may be that the simpilest answer to this, is to create a custom column, dividing the column you with to convert to a percentage by 100 and then formatting that as a percentage.

 

You can then hide the original column in your model so that it isnt used by accident.

 

Thanks

Anonymous
Not applicable

The original column with the percentage values was filtered so that it would show the average percentage. Unfortunately, I was not able to create a new calculated column from the original column (because it used the average filter). I had to recreate the average filter, and then use the steps you mentioned.

 

Thanks!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.