Forum Discussion

raymondxie's avatar
raymondxie
Helper II
9 years ago
Solved

How to change column format?

In my data source I have varchar field with the content of a serial number, power bi shows it as scientific number automatically, how can I change it back to text? e.g. "123456789" is displayed as 1....
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi raymondxie,

     

    Using this formula: Column = format('TableName'[ColumnName],"###-###-###") , you can format the field to display as "xxx-xxx-xxx". But you should note that the data type of this field will be changed to Text rather than number.

     

    Besides, it is not allowed to format the field styles (font and size, ...). 

     

    Best regards,
    Yuliana Gu

raymondxie's avatar
raymondxie
Helper II
9 years ago

Alright, I figured it out, after the Data Type of the text field is changed from text to Whole Number and the Format changed from Text to Whole Number, the field is displayed as a whole number in text.

 

 

My new question is:

 

In Power BI, is there anything like custom format? I want to show the field in the format of: xxx-xxx-xxx, how can I do it? what about the styles (font and size, ...)?

 

Thank you

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi raymondxie,

 

Using this formula: Column = format('TableName'[ColumnName],"###-###-###") , you can format the field to display as "xxx-xxx-xxx". But you should note that the data type of this field will be changed to Text rather than number.

 

Besides, it is not allowed to format the field styles (font and size, ...). 

 

Best regards,
Yuliana Gu