Forum Discussion
Formatting date columns while preserving data type
Hello, Is there a way to format datetime columns to any other formats besides the formats listed in Power BI Desktop while preserving the datatype? Please see the screenshot below. ...
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)
Hey Anonymous ,
maybe you want to create an issue here: issues.powerbi.com
Regards,
Tom