Forum Discussion
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....
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
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
