Forum Discussion

Omabuwa1995's avatar
Omabuwa1995
Regular Visitor
8 years ago

PowerBI date formatting issue

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 calend...
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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 Yu

Omabuwa1995's avatar
Omabuwa1995
Regular Visitor
8 years ago

Hi v-qiuyu-msft,

 

I am using the PowerBI web version, not the desktop. 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi 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 

    • Lifan's avatar
      Lifan
      Frequent Visitor
      8 years ago

      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?

    • Omabuwa1995's avatar
      Omabuwa1995
      Regular Visitor
      8 years ago

      Hi v-qiuyu-msft

       

      My browser display language is English UK yet the slicer still shows a US date format.