Reply
Frequent Visitor
Posts: 5
Registered: ‎12-05-2018
Accepted Solution

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


Accepted Solutions
Community Support Team
Posts: 2,232
Registered: ‎02-06-2018

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

View solution in original post


All Replies
AlB Super Contributor
Super Contributor
Posts: 860
Registered: ‎11-12-2018

Re: Year Filter Not Working

[ Edited ]

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

Community Support Team
Posts: 2,232
Registered: ‎02-06-2018

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