Visual not filtering if contains a certain value

[Anonymous]

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.

[v-lili6-msft]

hi  @Anonymous 

There should be something wrong in the data.

Could please share your sample pbix file for us have a test? that will be a great help.

Regards,

Lin

[Anonymous · Accepted solution]

Hi Lin,

Apologies, I have managed to fix it now.

I have to create a new column called yesterday which displays yesterdays date i.e. Today()-1 and then create a new if column which displayed if the opportunity date is yesterday or not e.g. if(date=yesterday, "Yesterday")

Thanks for the support.

[v-lili6-msft]

hi  @Anonymous 

It's pleasant that your problem has been solved, 😁  please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.

Regards,

Lin

[Greg_Deckler]

This is in the Desktop? Did you recently update? What version are you on? File | Options and settings | Options | Diagnostics.

[Anonymous]

Yes this is in desktop, I am on the latest version:

Version: 2.79.5768.721 64-bit (March 2020)