cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ashfaq Frequent Visitor
Frequent Visitor

Year Filter Not Working

Hello Experts,

 

I'm exploring power BI, I just encounter follower error on selectiong year Filter,

Any idea on how to resolve this?

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Year Filter Not Working

Hi Ashfaq,

 

You may have done some change in query editor, right? Text type can't be changed to date type directly so the error happens, as a workaround, you can create a custom column to convert text to date in query editor using function as below than use the custom column instead of original column in your visual:

Date.FromText(date as nullable text, optional culture as nullable text) as nullable date 

 

Regards,

Jimmy Tao

2 REPLIES 2
Super User
Super User

Re: Year Filter Not Working

Hi @Ashfaq

It looks like an issue with data types mismatch. If you share your file it would be much easier for people to help

Highlighted
Community Support Team
Community Support Team

Re: Year Filter Not Working

Hi Ashfaq,

 

You may have done some change in query editor, right? Text type can't be changed to date type directly so the error happens, as a workaround, you can create a custom column to convert text to date in query editor using function as below than use the custom column instead of original column in your visual:

Date.FromText(date as nullable text, optional culture as nullable text) as nullable date 

 

Regards,

Jimmy Tao