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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
hendraoui
Regular Visitor

Convert text to pourcentage

Hello everybody,

 

How to convert a value with type text in pourcent?

 

Thanks 🙂

1 ACCEPTED SOLUTION

We just had to replace the empty cells with null 😉

 

 

View solution in original post

7 REPLIES 7
tamerj1
Super User
Super User

@hendraoui 

Ah.. you want to use Power Query? Then just replace the "," with "." then change data type to %

I try this but does not 😞

 

hendraoui_0-1672824939048.png

 

hendraoui
Regular Visitor

it looks like this:

 

hendraoui_0-1672824192553.png

 

hi @hendraoui 

 

it looks like you have data from a specific locale, like Germany.

 

try to

1) right click the column, choose Change Type -> Using Locale, choose Decimal Number and English(Germany), and OK to close. 

FreemanZ_1-1672827429283.png

 

2) change it to percentage as usual. 

 

We just had to replace the empty cells with null 😉

 

 

@hendraoui 

I tried from my end and Power Query automatically converted the text to number without me even doing anything. Make sure to check if you have some cells that contain letters or  hidden special characters. You may also try Tranform - Trim and Trasform - Clean if you cannot see any visible character. 

tamerj1
Super User
Super User

Hi @hendraoui 

It depends on how the text look like?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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