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

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.