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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
UIUser
Frequent Visitor

Date formatting in wrong way when converted to text

Hi, 

 

I have a date that I need to connect with a text piece. Now when I combine my selected date with the text the date comes out in a wrong format (US date format, MM/DD/YYYY, 1/31/2025) allthough all my regional settings are set to german / european:

Dax:

UIUser_0-1746631508809.png

Result:

UIUser_2-1746631524106.png

 

Originally the date column has this format (german / european) -> DD/MM/YY -> 31.01.2025

UIUser_3-1746631650739.png

 

 Why does the text come out as US date allthough all settings are german / european format and how to change it?

 

Thanks!

1 ACCEPTED SOLUTION
DataNinja777
Super User
Super User

Hi @UIUser ,

 

The issue occurs because when you concatenate a date with text in DAX, Power BI implicitly converts the date to a string using the default US format (MM/DD/YYYY), ignoring your regional settings. This happens even if your system or file is configured for German formatting. To fix this, you need to explicitly format the date before concatenation. Use the FORMAT function to define the correct European date structure. For example, instead of relying on SELECTEDVALUE to output a date directly, wrap it like this:

header_ertragleer_previous_month = 
"Ertrag leer per " & FORMAT(SELECTEDVALUE('bm dim_month'[month_end]), "DD.MM.YYYY")

This ensures the date appears as 31.01.2025 regardless of Power BI’s internal preferences. If you want to reinforce the language tag just in case, use the following format string:

header_ertragleer_previous_month = 
"Ertrag leer per " & FORMAT(SELECTEDVALUE('bm dim_month'[month_end]), "[$-de-DE]dd.mm.yyyy")

This forces the German locale format and avoids any surprises when the report is opened elsewhere.

 

Best regards,

View solution in original post

3 REPLIES 3
v-nmadadi-msft
Community Support
Community Support

Hi @UIUser 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

 

v-nmadadi-msft
Community Support
Community Support

Hi @UIUser  ,
Thanks for reaching out to the Microsoft fabric community forum.

As mentioned by @DataNinja777  , I tried to implement their suggestion and it has successfully worked at my end

vnmadadimsft_0-1746697226823.png

 


Give this a try it will most likely resolve the issue.

 

Furthe Reading: SELECTEDVALUE function - DAX | Microsoft Learn
FORMAT function (DAX) - DAX | Microsoft Learn


If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

DataNinja777
Super User
Super User

Hi @UIUser ,

 

The issue occurs because when you concatenate a date with text in DAX, Power BI implicitly converts the date to a string using the default US format (MM/DD/YYYY), ignoring your regional settings. This happens even if your system or file is configured for German formatting. To fix this, you need to explicitly format the date before concatenation. Use the FORMAT function to define the correct European date structure. For example, instead of relying on SELECTEDVALUE to output a date directly, wrap it like this:

header_ertragleer_previous_month = 
"Ertrag leer per " & FORMAT(SELECTEDVALUE('bm dim_month'[month_end]), "DD.MM.YYYY")

This ensures the date appears as 31.01.2025 regardless of Power BI’s internal preferences. If you want to reinforce the language tag just in case, use the following format string:

header_ertragleer_previous_month = 
"Ertrag leer per " & FORMAT(SELECTEDVALUE('bm dim_month'[month_end]), "[$-de-DE]dd.mm.yyyy")

This forces the German locale format and avoids any surprises when the report is opened elsewhere.

 

Best regards,

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.