Make column into %

Question

Hi,&nbsp;I have column that is in number format.The data comes from sharepoint and which comes from Power Apps.I would like to convert into a % (without having to change Power Apps or Sharepoint List)Do i add New Measure, Do i add a New Column or Do i use Dax?&nbsp;&nbsp;

anonymous · Answer

If in Power Query, just apply a transformation to the column: divide the value by 100.

anonymous · Answer

Thanks,&nbsp;Where do i do that?I clicked on Transform Data....&nbsp;

anonymous · Answer

If it's not available in any of the mathematical transformations, then you can always use 'Add New Column' and perform the operation in there. Then remove the old column.

anonymous · Answer

You can create new measure calling same column and divide it by 100
Once measure is created convert it into percentage.

Sample DAX = Max([Test])/100,
Click on % sign in measure tools to convert it to Percentage.

Hope this helps.

Thanks,
Ashwin Kulkarni

anonymous · Answer

Anonymous&nbsp;1. Open Transform&nbsp;Data, create a custom column from the top menu bar.
2. Remove the original column in power query.

&nbsp;
3. Under home tab change&nbsp;the data type to percentage.

&nbsp;
&nbsp;
Paul Zheng _ Community Support TeamIf this post helps, please Accept it as the solution to help the other members find it more quickly.
&nbsp;

Forum Discussion

Make column into %

6 Replies

Related content

How to make a 1-20 column

Make Parameter effective using calculated column

Help Making Column Headers (Dates) Dynamic in PBIX

How to make clustered column chart columns overlap?

How to make warehouse queries faster and make reports upto date without getting failed