Forum Discussion
PowerBI date formatting issue
Hi Omabuwa1995,
The date format in the slicer textbox is based on the OS region date format.
In your scenario, when you select the 01 Feb 2018 in the calendar for the start date, the slicer start textbox will displays as 2/1/2018 is due to the OS region date format is dd/mm/yyyy. If you would like to display it in UK mm/dd/yyyy format, you can change your OS region date format then reopen the pbix file.
But if OS date format is dd/mm/yyyy, once you select 01 Feb 2018 in the calendar, it's not supported to display it as 2 January (2/1/2018).
Best Regards,
Qiuyun Yu
The OS date format is the UK DD/MM/YYYY yet PowerBI still uses the US date format.
My issue is similar to this issue: https://community.powerbi.com/t5/Desktop/Date-format-changing-desktop-to-web/td-p/117204
Yet the solution provided doesn't work, as the PowerBI is already set to use the default browser language.
Hi Omabuwa1995,
Do you use the Power BI desktop downloaded from download site or Windows store?
Based on my test with Power BI desktop latest version 2.59.5135.781 64-bit (June 2018) downloaded from download page, the slicer display date in the format as OS date format settings. See:
In your scenario, please update the Power BI desktop version then test again.
Best Regards,
Qiuyun YuHi Omabuwa1995,
On Power BI service, the date format within the slicer depends on the browser language. Based on my test, if set the Chrome browser as English (United Kingdom), which date format is dd/mm/yyyy, then slicer date is displaying in the same format as well.
So please which language you used for the browser.
Best Regards,
Qiuyun Yu