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
Anonymous
Refer, if these can help
https://www.tutorialgateway.org/how-to-format-dates-in-power-bi/
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
- Anonymous6 years agoNot applicable
Hi amitchandak ,
How do we show a date in a custom format in visuals, say "Mon 12/03/2015" while preserving its data type to date?
I am afraid, the links you provided were not relevant to the question. I am happy to be wrong on this.