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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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