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

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Go to the Data View, Select modelling Tab, Change the data type to Text.

  • 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.