Duplicate change column type

[prothinker]

Hi

I have an existing table with multiple columns and I manually changed each column's type from Text to Fixed Decimal Number and Format to Decimal Number. I will be creating multiple tabs with same no. of columns and column names. Is there a way to avoid manually changing each column in each tab? I tried to go to Transform Data/Advanced Editor and copy the whole line starting with #"Change Type" and copying to the new table but it does not seem to work.

Thanks.

[v-henryk-mstf · Accepted solution]

Hi @prothinker ,

Based on my test, if we use Currency General format, the auto decimal point option will be still available.

On the left pane under Current file, select Data load. On the right pane under Type detection, select whether you want to enable or disable type detection for the current file.

related document link:

Data types in Power BI Desktop - Power BI | Microsoft Docs

Data types in Power Query | Microsoft Docs

If the problem is still not resolved, please provide detailed error information screenshoot and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @prothinker ,

go to Power Query, select all the columns you want to change with pressed Ctrl or Shift key and then change all at once with the "Data type" option:

This you only have to do once, then the data type is changed in the whole report

Data types in Power Query | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[prothinker]

Thanks. I managed to change the columns to Fixed Decimal Place. How do I change the Format from Currency to Decimal Number. I tried Rounding and selected 2 decimal place but it didn't work.

[selimovd]

Hey @prothinker ,

you just chose "Currency" instead of "Decimal number":

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[prothinker]

I changed to Fixed Decimal Place and then used Rounding to change to 2 decimal place. However, the numbers appear with the $ sign. How do I just have two decimal-place numbers without the currency sign? Thanks.