Forum Discussion

ytech_teo's avatar
ytech_teo
New Member
8 years ago

Thousands separator

Hi,

 i have an integer value: 5345

When i select the 'Thousands separator' the field display 5,345 , but i don't want

comma with separator, i want point: 5.345.

In my Power Bi desktop the Regional Setting is 'Italian'

How can i do?

 

Thanks

Matteo

 

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi ytech_teo,

     

    Do you set the 'Thousands separator' in data source or in Power BI desktop? As I didn't find such an option in desktop that can format the whole number to Thousands. Did you see 5,345 in table view or in visualization?

     

    Regards,

    Yuliana Gu

    • ytech_teo's avatar
      ytech_teo
      New Member
      8 years ago

      Hi,

         on configuration of Power BI Desktop i selected 'Italian Regional Setting' but in visualization i see 5,345.

      After the publishing  on line i see correctly 5.235.

       

      Thanks

      Matteo

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi ytech_teo,

     

    You said "i select the 'Thousands separator' ", where to find this option?

     

    Regards,

    Yuliana Gu