How to get change date format

[hb0135]

Hello,
I have mix data of ABC & 123 when i create the chart in power BI i.e in pbix file the date format is ok as shown below eg-01-06-2024

But when i published the report the date format is change as shown below eg-6/1/2024

BR

hb0135

[hb0135]

Hello,
Where to get the power BI service regional setting i tried but i didnot find please guide me for that
BR

HB0135

[v-yiruan-msft · Accepted solution]

@rajendraongole1  Thanks for your contribution on this thread.

Hi @hb0135 ,

Power BI service uses the browser’s language settings, you can refer the following blog to set the proper date format in Power BI Service:

Manage Date Formats in the Power BI Service

Best Regards

[hb0135]

Hello,
Thanks for the help
Regards

[rajendraongole1]

Hi @hb0135  - Create a new column in your table with a formula like this

FormattedDate = FORMAT([YourDateColumn], "dd-mm-yyyy")

or  Sometimes, the browser’s locale settings can affect the date format displayed in Power BI Service. Ensure that the browser’s language and region settings match your desired date format.

Desktop:Go to File > Options and settings > Options.
Under Regional Settings, ensure that the locale is set to the region that matches your desired date format.

do the same by configuring the Power BI Service Regional Settings too.

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