Forum Discussion
Solved
Creating a Simple Month-Over-Month Line Graph (Relationship Issue?)
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 ot...
I suggest you change the datatype in Power Query.
Right click on timestamp column --> Change Type --> Date
Refresh the dataset and please check again
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
Yup thats what worked, the change had to be made in the Power Querey - Thank you so much!