Forum Discussion

prothinker's avatar
prothinker
Frequent Visitor
5 years ago
Solved

Duplicate change column type

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...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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's avatar
selimovd
Most Valuable Professional
5 years ago

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
 
  • prothinker's avatar
    prothinker
    Frequent Visitor
    5 years ago

    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's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      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
       
      • prothinker's avatar
        prothinker
        Frequent Visitor
        5 years ago

        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.