m1032499's avatar
m1032499
Frequent Visitor
9 years ago
Status:
Done

Date Display Format in Date slicer

Hi,

 

I am having trouble with the format of the date displayed in the Date slicer of power BI.

The dates in my data are in UK format but the date slicer is displaying them in US fromat.

 

Attaching screenshot of sample report: DateSlicerDateFormat

Please help.

11 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    m1032499

     

    Please go to system control pane to change the region format to UK. Then close and reopen the PBIX file to see the result.

     

     

    Best Regards,
    Herbert

    • m1032499's avatar
      m1032499
      Frequent Visitor

      v-haibl-msft

       

      Thanks for this. I was able to change the format in the desktop version, but the published version is still showing the US fromat. 

      Please help.

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    m1032499

     

    I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 41498435
    I’ll post here once I get any update about it.

     

    Best Regards,
    Herbert

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    m1032499

     

    I’ve got response from the Product Team.

     

    This is being tracked by a bug internally. But for now that is by design.

     

    Best Regards,
    Herbert

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    m1032499

     

    If you want to use the minimal UK date formats, you can set your browser to UK locale as following screenshot.

     

     

    Best Regards,
    Herbert

  • kdonahue100's avatar
    kdonahue100
    Frequent Visitor

    We're having this same issue.  We have hundreds of clients all in Australia using the reports, and I don't want to have to ask them to update their browser settings.  Is there any way we can force the visualization to display in the format we have specified?  I set the format of the date for the slicer to "d/MM/yyyy", but it still displays in American format for most of our users.

  • jeaninnes's avatar
    jeaninnes
    Frequent Visitor

    I'm having the same issue.  I'd love to know a resolution to this.

     

  • This problem is present in Power BI Service. Any fixes in view? 

  • jeaninnes's avatar
    jeaninnes
    Frequent Visitor

    So I think I found a fix to this, at least if you are using Google Chrome browser.   In Google Chrome settings, Advanced, select your language as English (United Kingdom).  I have used either English (Australia) or English (United Kingdom) and they both work.   Then in Power BI service, go to settings and make sure your language is set to use the browser default.

     

    Doing this, I have been able to get my report slicers display the date correctly for Australia.  However - I realise that this does require all users to update their browser settings - which might not be the solution you are after.