Forum Discussion

Gianluigi's avatar
Gianluigi
Icon for Helper II rankHelper II
3 years ago

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 correctl...
Need Help
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

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).

  • Gianluigi's avatar
    Gianluigi
    Icon for Helper II rankHelper II
    3 years ago

    Hi,

    the settings seem correct