Date format in display

[ILoveAutomating]

How can I display the date in dd/mm/yyyy format?  The data in the table "shows" the date in dd/mm/yyyy format.  But when it is displayed on the report, it is presented in mm/dd/yyyy format. 

[Anonymous · Accepted solution]

Hi @ILoveAutomating ,

When importing flat files into powerbi, they are processed according to local default settings.
If you want to keep the date form in the REPORT consistent with the format in the table, you can set it in the following area.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ILoveAutomating]

Hi @PijushRoy 

I do not see the Locale option.  See the screenshot below.

[Thejeswar]

HI @ILoveAutomating ,

You can manually set the format in which you need the date to be displayed.

Find below the screenshot showing the same

[ILoveAutomating]

I am adding the 2 screenshots to show how the data is displayed and how the same field when used in a report is displayed.

 

[PijushRoy]

Hi @ILoveAutomating 
LOCALE option is available in Power Query editor
Also region setting available in Power BI option
Please follow the articles in details

[ILoveAutomating]

The screenshot that I shared is from Power Query.

Also, in the Power BI options, I have checked the regional settings.  I also changed them to other countries with dd/mm/yyyy usage, but the display in the report always remains mm/dd/yyyy.

In case my initial message was confusing:

the data imported in PowerBI is dd/mm/yyyy (see my screenshot).  It is only when the data is displayed on a report that it is in mm/dd/yyyy format.

[PijushRoy]

Hi @ILoveAutomating 

Please use LOCALE option and location setting
https://tanducits.com/tips-and-tricks/4-ways-to-fix-date-errors-in-power-query--locale--regional-set...

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin