Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
bomiekim
New Member

Percentage Conversion - Power BI Desktop

Hi team,

 

I am pretty new to Power BI Desktop. I have been trying to convert my values to %, and it hasn't been working. 

For example, if I have 0.10 and press "%" button on the ribbon under 'Modeling' tab, it won't convert the number to 10%. I have figured out a way around it by using format() function, but it's rather inconvenient.

 

Is there a solution to this problem? 

 

Thank you!

 

Bomie

 

2 REPLIES 2
airshiner
New Member

I'm having a slightly different problem. I have a list of decimal numbers that I just want to change to percentages. For example, I have 75.577 and I want to convert to 75.6%. However, in the "Edit Queries", it changes it to 7,557.7%. Anyone have and idea how to fix this?

Greg_Deckler
Super User
Super User

I had this issue for a while but the newest version of Desktop seems to have fixed it for me. I am on:

 

2.33.4337.501 64-bit (March 2016)


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors