Reply
Frequent Visitor
Posts: 14
Registered: ‎12-21-2016
Accepted Solution

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


Accepted Solutions
Moderator
Posts: 9,419
Registered: ‎03-06-2016

Re: Issue: Power BI interpreting date incorrectly

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Moderator
Posts: 9,419
Registered: ‎03-06-2016

Re: Issue: Power BI interpreting date incorrectly

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Posts: 754
Registered: ‎06-03-2016

Re: Issue: Power BI interpreting date incorrectly

[ Edited ]

Hey ,

 

Here the format is Month Day Year.

 

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

 

Or change regional setting 

1.JPG

 

 

 

 

Frequent Visitor
Posts: 14
Registered: ‎12-21-2016

Re: Issue: Power BI interpreting date incorrectly

Hi Baskar,

 

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

 

Thnak you for your help.

 

simon

Highlighted
Frequent Visitor
Posts: 14
Registered: ‎12-21-2016

Re: Issue: Power BI interpreting date incorrectly

Hi Quiyun Yu,

 

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

 

many thanks, 

 

Simon