Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Custom formatting date columns for visuals (still keeping the datatype to date)


I have a date column which is recognised as "date type" by PowerBI. This column works as expected when put on visuals. However, I want to format the appearance of this date to "ddd dd/mm/yyyy" for visuals.

If I convert the column to the above format, it is not recognised as 'date' type anymore, therefore, visuals show the dates as "categorical values" rather than continous date values.

Is there a way to custom format a date column while preserving its data type?



Hi @amitchandak 


I want to show dates as "Wed 12/03/2018" . Using the FORMAT() function is not helpful because it converts date column to "text", therefore, visuals then don't know that they are working with dates anymore. 


Hi @Surm


Is your issue solved?If so,can you mark the post as answered?


Much appreciated.


Best Regards,
Did I answer your question? Mark my post as a solution!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors