Forum Discussion

NCPowerBI's avatar
NCPowerBI
Helper I
3 years ago
Solved

Formula for Correct Percent Conversion

Hi all,   I'm receiving a decimal number format coming out of my query into BI and it needs to be converted to a percentage. However, when I convert to %, it turns numbers to the left of the decima...
Need Help
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    Hi NCPowerBI 

    Is it an option for you to divide the column by 100 in Power Query?

     

    If so, in Power Query go to the Transform tab and in the Number Column section, press Standard and select Divide.

     

grantsamborn's avatar
grantsamborn
Solution Sage
3 years ago

Hi NCPowerBI 

Is it an option for you to divide the column by 100 in Power Query?

 

If so, in Power Query go to the Transform tab and in the Number Column section, press Standard and select Divide.