Change data type in a column

[Anonymous]

Hi

I have a column in the data in which there are numbers (like mentioned below) and how do i change it to percentage?

Increase %
103.4122
80.8103
103.0319
124.7193
89
75.5462
115.3916

[Fowmy · Accepted solution]

@Anonymous 

If you need to show it as Percentage, then divide the values by 100 by adding another column in your table using DAX or under transform TAB in Power Query choose Divide by 100. Then, you can choose Percentage format

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn 

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

It's not in the Transform Data area.  You need to click into the Data tab and the menu at the top shows Formatting options.  You can reduce the number of decimal places here too.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Fowmy · Accepted solution]

@Anonymous 

If you need to show it as Percentage, then divide the values by 100 by adding another column in your table using DAX or under transform TAB in Power Query choose Divide by 100. Then, you can choose Percentage format

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn 

[Anonymous]

Hi

I did that. I cant seem to find the formatting option in Transform tab, how to reduce the decimal points? for example i have 103.41% i want to change it to 103.4% or 103%

[PhilipTreacy]

Hi @Anonymous 

You don't.  It stays a number type and you can then present it in visual or other form as a percentage.  You can divide the number by 100 then set the formatting in the data view to percentage for the column

What exactly do you want to do?

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Hi

I want to show the average of these percentages by category in the visuals