cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Gianluigi
Helper I
Helper I

format Date

HI,
I import a csv file 

 

02/10/2023;10/10/2023
31/12/2023;02/01/2024
04/05/2023;01/06/2023
10/03/2021;10/04/2021

 

power bi recognizes the date ( dd/mm/yyy Italian) by importing it correctly

 

if I transform the field of type date into string , the date becomes mm/dd/yyyy

see Attachment

 

HelpImmagine3.jpgImmagine2.jpgImmagine1.jpg

 

 

 

 

2 REPLIES 2
vicky_
Super User
Super User

You can use FORMAT([date], "dd/mm/yyy") to force it to display in a certain format. Other than that, check that your local pc (windows) settings are using the correct date format, or take a look at the Power BI settings under File > Options > Regional Settings (both Global and Current File).

Hi,

the settings seem correctImmagine5.jpgImmagine4.jpg

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors