Forum Discussion

AbrahamMarquez's avatar
AbrahamMarquez
Frequent Visitor
4 years ago
Solved

Decimal number formatting error

Publishing a project changes the format to show thousands and decimals. In Power BI Destok, it shows it to me in an adequate way to my requirement, which is with the format for Latin America and when publishing it it changes it to the format of Spain

Format for Latin America (1,000.00)

Format for Spain (1.000,00)

How can I solve this problem)

  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi AbrahamMarquez 

     

    The format is influenced by the Language Settings in your Power BI Service. Change the language to English then you will see the decimal numbers formatted correctly. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

4 Replies

  • Forgive me if I'm missing something but the two examples look the same to me (1,000.00).

    Was there a mistyped section?

  • Hi

    My problem is that in PowerBI Destok if it correctly shows me the format for decimals and miles (10,000.00) commas for thousands and point for decimals, but when publishing it it changes the format to (10,000.00), that is, commas for decimals and point for miles

    Thank you for your support and response.

    • v-jingzhang's avatar
      v-jingzhang
      Icon for Community Support rankCommunity Support

      Hi AbrahamMarquez 

       

      The format is influenced by the Language Settings in your Power BI Service. Change the language to English then you will see the decimal numbers formatted correctly. 

       

      Best Regards,
      Community Support Team _ Jing
      If this post helps, please Accept it as Solution to help other members find it.