Forum Discussion
Creating a Simple Month-Over-Month Line Graph (Relationship Issue?)
I suggest you change the datatype in Power Query.
Right click on timestamp column --> Change Type --> Date
Refresh the dataset and please check again
If this is the case then i suggest you do the following:
1st try creating the same graph but instead of using date from calendar table use the timestamp from sales table.
If the graph is displayed then there may be a problem with the relationship between the 2 tables
I tried that as well, and it did show a problem with the relationship between the two table, but the problem is, what could that problem be when the format and data type are the same?
are you certain that the timestamp field doesnt contain time as well ... and it has only dates?
The timestamp column in the original format does include the time as well - however I switched it to only Date in the Data field. Could that be the issue?
I suggest you change the datatype in Power Query.
Right click on timestamp column --> Change Type --> Date
Refresh the dataset and please check again