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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
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.