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
Quenjo
Helper II
Helper II

How to handle date format "YYYY-MM-DD" when transforming data ?

Hi community,

 

I have quite a strange issue, let me show you some examples :

 

Quenjo_0-1664289199209.png

 

When importing data from the database it imports the dates as a "Text" field.

When I change the "Text" into "Date" format, here is the output :

Quenjo_1-1664289247636.png

 

This is exactly what I am expecting. However, when saving my modifications, on my report I have the following :

Quenjo_2-1664289323661.png

 

How is it possible ? How can I handle this ?

Taking into account that on my preview everything seems to be fine...

 

I cannot let the field be in "Text" format because I need to do some filtering on the dates.

 

Many thanks for the help provided.

 

Jonathan

 

 

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @Quenjo 

 

In Power BI Desktop, switch to Data view, select your Date column, ensure its Data type is Date and change its Format to dd.mm.yyyy in Column tools ribbon. 

vjingzhang_0-1664334531514.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @Quenjo 

 

In Power BI Desktop, switch to Data view, select your Date column, ensure its Data type is Date and change its Format to dd.mm.yyyy in Column tools ribbon. 

vjingzhang_0-1664334531514.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

amitchandak
Super User
Super User

@Quenjo , Make sure the data type is date in both power query and in DAX. Check column tools for data type

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.