Forum Discussion
Anonymous
4 years agoNot applicable
Error converting number to date
Hi All, Need urgent help! I am not able to add trend line when i switch the x axis from annual to quarterly time interval. When i am switching the axis type to continuous it automatically switches ...
v-kkf-msft
4 years agoCommunity Support
Hi Anonymous ,
Please check if you meet the following conditions:
- The x-axis value needs to have a date/time format or be a uniformly increasing whole number.
- It can’t contain text or decimal numbers.
- Sometimes x-axis values appear to be dates, but they’re actually formatted as text. They won’t work for forecasting.
- The chart has to have only one line. Multiple-line charts don’t work, even if all but one line is filtered out.
- The line chart has to have fewer than 1,000 values. Power View samples data in charts with more than 1,000 values, and forecasting won’t work on sampled data.
- The four most recent values in the time series must increase uniformly, meaning there’s the same length of time between each value.
- The interval between values has to be at least one day.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.