Problem with comma in my decimal column

[nok]

Hello,

I want to change my "Value" column to decimal type, but when I do this, Power BI ignores commas and assumes it is one large combined number.

How my column originally appears in Power Query:

How it looks when I change it to decimal type:

How can I fix this issue using Power Query?

[HotChilli · Accepted solution]

delete the 'changed type' step. Use Change Type (using Locale) which you can reach by right-clicking on the column header

[AlexisOlson]

Use an appropirate culture option on the Table.TransformColumnTypes step.

For example, including the "fr-FR" argument should do what you need.

= Table.TransformColumnTypes(Source, {{"Value", type number}}, "fr-FR")