Forum Discussion
Formatting date columns while preserving data type
Hey,
Power BI Desktop provides the possibility to create custom format while preserving the date or datetime datatype.
The picture below demonstrates how this can be achieved:
It all starts with the Model view (1).
You are able to define your own format by using the available abbreviations in the text field (4).
Here is a simple table visual that shows the format:
Hopefully, this provides what you are looking for.
Regards,
Tom
Super UserHey,
Power BI Desktop provides the possibility to create custom format while preserving the date or datetime datatype.
The picture below demonstrates how this can be achieved:
It all starts with the Model view (1).
You are able to define your own format by using the available abbreviations in the text field (4).
Here is a simple table visual that shows the format:
Hopefully, this provides what you are looking for.
Regards,
Tom