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

Thank you.

 

We overlapped posting.

 

I already updated it and still not working. I added more questions to the original post.

 

Thanks.

 

ps.

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

raymondxie

 

2.   Select your Date column and change the check Date Hierarchy to your column name

 

 

3. Just drag the colum up or down in the panel.

  • raymondxie's avatar
    raymondxie
    Helper II
    9 years ago

    Thank you Vvelarde, what about item 1? how to disable the field being displayed as scientific way?

     

    And how do I change the grid's style(font,size,color....)

     

    Thanks for your help.

    • 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