Whenever I try to select a date range, PowerBI muddles up the report period and gives reports for the wrong dates. For example, if I try to select the range 01 Feb 2018 - 01 March 2018 via the calendar, the report period gives an output of 02/01/2018 - 03/01/2018.
The PowerBI apparently uses the UK date format, however in that example it would attempt to draw data from the 2 January - 3 January.
When i am creating a dashboard in Power BI, i have a coloumn named as Month of Data.
In the desktop version the Date is displayed correctly as "Apr" or "May" but when i publish this and opens in the web version the date changes automatically to "01/04/2019 00:00".
Can anyone help me? I need the date format same as desktop version.
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).
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.
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.
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.
I have exactly same problem.
Windows region setting is correct, also followed steps to change the language setting for browser, set the PowerBI servise language to Browser. Still BI display US format, and I'm in Australia.
Any other place to check?
p.s. this idea of relying on user Brower setting is not great I have to say. As we publish report to all the executives, have to tell them to change their browser setting to view it correctly?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.