Forum Discussion
How to get change date format
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
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
4 Replies
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.
Hello,
Where to get the power BI service regional setting i tried but i didnot find please guide me for that
BRHB0135
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
Hello,
Thanks for the help
Regards
