Forum Discussion
Change data type in a column
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 |
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 🙂
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.
5 Replies
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 🙂
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.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.