Forum Discussion
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.23456789e+008, I tried to change its format to General but it doesn't seem to take it, maybe there is some other way to change it?
I also have a date field where the PowerBI automatically splits it into Year, Quarter, Month and Day, I only want to show it in one column like: 2016-10-26, is there a way to hide/display column?
How can I adjust the order of the columns?
Thanks.
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
7 Replies
Go to the Data View, Select modelling Tab, Change the data type to Text.
Thank you.
We overlapped posting.
I already updated it and still not working. I added more questions to the original post.
Thanks.
ps.
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.
