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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

Reply
Syndicate_Admin
Administrator
Administrator

Add decimals to integer

Dear

I can't visualize the decimals in a table, it shows me the field as an integer (Surely the point separating the decimals I take as thousands).

I have 2 tables with different formats: In one the decimals separated with commas "," but in another I have the decimals with periods "." and that is why the Power BI takes the amount without decimals (It shows it as an integer).

For example, in the AMOUNT column:
The number appears integer: "45756050"

I need it to appear: "457560,50"

Changing the numeric format to text in Power Query doesn't show me the decimal point either.

Is there a possibility to add the decimal symbol "," before the last 2 numbers?

I appreciate your help.


Best regards

Martin

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Syndicate_Admin , Create a new column

 

[Amount]/100

 

data type decimal

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Syndicate_Admin , Create a new column

 

[Amount]/100

 

data type decimal

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.