You should have "continuous" axis to put trend line.
In attached file case, change it to "exact date" and you ill get trend lie option.
But the number of data point is not sufficient, line does not make sense.
MPU Simulation_SM_10.3.twbx 2.1 MB
1 of 1 people found this helpful
My date type include month/day/year:hh:mm
However, I ended up truncating the date at the source in all of my joins using this calculation (I had to in order to get my target goals for each month in a different workbook to actually show up):
The hours and minutes in the goal data always read 12:00 AM and wouldn't match up with other data I had (the target goals) so I ended up taking that all out. I wonder how I can fix this issue.
In any case, thanks for your help. It is appreciated.