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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply

Changing date format that won't change with regional setting difference

I've been working on a report that some clients are having one date filter displayed in US format (mm/dd/yyyy), while the rest of the dates are in UK format (dd/mm/yyyy). I understand this is due to the regional setting of the user, but I wanted to know if there is a way around this? That I could configure all dates to only one format? In this case (dd/mm/yyyy)? 

 

I tried usng the locale query but it did not work, changing the column also has not helped much, is there anything I could do to fix this? Thanks in advance

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

try to wrap it with FORMAT, e.g.

FORMAT(TODAY(), "DD/MM/YYYY")

View solution in original post

3 REPLIES 3
FreemanZ
Super User
Super User

try to wrap it with FORMAT, e.g.

FORMAT(TODAY(), "DD/MM/YYYY")

Hi, is this for the Power query? Or where do I apply this? Haven't heard of that one before.

 

Also do I have to use this for every single date table/column there is? thanks in advance

this is DAX code, you may create a column with this code.

@Amazing_Random 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors