Visual showing 1970 for date

[Anonymous]

Hey

I have a visual which uses the uses the Date and Count of Intake Received On date to plot a clustered column chart.

 In Dev and Test this works perfectly well. see the chart below pointing to the Dev envrionment dataset

But when I point the dataset to Prod it shows as below.

Please what could be the possibe cause and the solution.

Note the relationship is thesame and data type

[CoreyP]

Without seeing the data and model I can't be sure. It's either an issue with the relationship and data types, or prod doesn't actually have any data that matches the current context. 

[Anonymous]

Dev data details

Caledar table details

Intake Received On Date details

Relationship in Dev

Prod Details

Calendar 

Intake Recieved On

Relationship

Please let me know if you need more info

[CoreyP]

Try changing the data type of "Intake Received On Date" to Date, not Date/Time.