Forum Discussion

Simon_Lou's avatar
Simon_Lou
Icon for Advocate IV rankAdvocate IV
9 years ago
Solved

Issue: Power BI interpreting date incorrectly

I'm having an issue when typing in visual level, page level and report level filters.

 

I am looking to type the date, then Power BI to 'autofill' the date I was typing once I have pressed enter.

 

The issue: when I type "12/1" and press enter, I would expect to see 12th January 2001 (2001 being the default year in this case). However, Power BI reads "12/1" to be 1st December 2001.  Is there anywhere / anyway I can change this?

 

Many thanks

Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Simon_Lou,

     

    How about add the Date column into the Visual Level filter, and type the value in this format: "1/12/2001"?

     

    Best Regards,
    Qiuyun Yu

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi Simon_Lou,

     

    How about add the Date column into the Visual Level filter, and type the value in this format: "1/12/2001"?

     

    Best Regards,
    Qiuyun Yu

    • Simon_Lou's avatar
      Simon_Lou
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      Hi Quiyun Yu,

       

      Yes - it appears that explicitly typing year removes the ambiguity in my issue.

       

      many thanks, 

       

      Simon

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    Hey ,

     

    Here the format is Month Day Year.

     

    So u can it to 1/12 , it will help u.

     

    Or change regional setting 

     

     

     

     

    • Simon_Lou's avatar
      Simon_Lou
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      Hi Baskar,

       

      I have tried this using different Locale settings and nothing changed.  

       

      Thnak you for your help.

       

      simon