Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Surm
Helper III
Helper III

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

Hello,

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?


1 ACCEPTED SOLUTION
4 REPLIES 4

 

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,
Kelly
Did I answer your question? Mark my post as a solution!
 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.