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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mincii
New Member

Change exisiting text type to decimal

Hi everybody

 

I am a beginner of powerbi and what to set up a new report in our company. I know that you can change the type of columns but I haven't figure out, how to have an exisiting column as type "text" and change it to type "decimal" with two characters after comma. 

 

Just to make it a little bit clearer:

 

mincii_3-1675091545297.png

 

1. Is 04909 ---> should be 49,09

2. IS 04906 ---> should be 49,06

3. Is 04711 ---> should be 47,11

4. .....

 

I tried also to transfer at first step to whole number and then to decimal. --> Did not work

 

As I want to change this in the query Editor and not in the Excel (This is the source of the column).

Can u maybe help me out? 🙂

 

Thank guys. 

 

Br, mincii

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

"I tried also to transfer at first step to whole number and then to decimal. --> Did not work

What happened?

This is the right way to do it.

Change type to number or decimal.

It looks like you want to divide by 100 and use a comma as a decimal separator so try that.

View solution in original post

2 REPLIES 2
mincii
New Member

Oh jes, just thought wrong. Thanks for the hint, got it.

HotChilli
Super User
Super User

"I tried also to transfer at first step to whole number and then to decimal. --> Did not work

What happened?

This is the right way to do it.

Change type to number or decimal.

It looks like you want to divide by 100 and use a comma as a decimal separator so try that.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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