Visual not filtering if contains a certain value

Hi All,

This one is confusing me a lot.

I have built a slicer called 'Yesterday' which shows all records and values where the corresponding date is yesterdays date.

All other visuals are filtering bar a card visual which displays 'Annual GP' and a table which also contains 'Annual GP' however a stacked bar chart where the value is 'Annual GP' filters fine.

It just states 'Can't Display Visual' and the details state the below:

Error Message:
Cannot construct data type date, some of the arguments have values which are not valid.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

Anybody come across this kind of issue before and been able to resolve it? Any ideas would be appreciated as I cannot figure out for the life of me why this isn't working.

It was working fine before today as well, so very confused.