Forum Discussion
Formatting date columns while preserving data type
- 6 years ago
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
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
Hi TomMartens ,
Please see the below screenshots.
When X axis is set to "Continous", it does not obey the custom format.
Type=CategoricalType=Continous (does not obey custom format)
- TomMartens6 years ago
Super User
Hey Anonymous ,
maybe you want to create an issue here: issues.powerbi.com
Regards,
Tom