Creating a Simple Month-Over-Month Line Graph (Relationship Issue?)

[Alvanor]

I am attempting to make a simple line graph that shows total monthly sales month-over-month, just as the example image below depicts. I have two imported excel data-sets; one is the sales log, the other is the calendar. I created a relationship between the calendar and the Timestamp column of the sales log and have ensured that they are the same data type and format.

However everytime I go to make the chart from the visualizations tools the chart appears blank, see image below:

I am so confused as to what I could be doing wrong as I have done this with previous data sets before with little trouble. 

Any help or insights anyone can provide would be greatly appreciated!

[themistoklis]

@Alvanor 

How do you connect the 2 tables?

It seems that cou link date from Calendar table with timestamp from Sales table.

If this is the case then you need to make sure that both fields are dates or timestamps

[Alvanor]

Hey there, well as I mentioned I already created the relationship between the two and ensured that they are both the same data type and format. Are you saying there is something else I need to do?

[themistoklis]

@Alvanor 

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

[Alvanor]

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?

[themistoklis]

@Alvanor 

are you certain that the timestamp field doesnt contain time as well ... and it has only dates?

[Alvanor]

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?

[themistoklis · Accepted solution]

@Alvanor 

I suggest you change the datatype in Power Query.

Right click on timestamp column --> Change Type --> Date

Refresh the dataset and please check again

[Alvanor]

Yup thats what worked, the change had to be made in the Power Querey - Thank you so much!