Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 back to  categorical. 

 

While changing quarter to date i am getting an error!

 

General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    Anonymous continuous option is only available when the column on x-axis data type is number or date, if it is text it will not work. check my video here on this https://youtu.be/rv2Ndm8JuGA

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      parry2k Thank you for help! I am getting an error while doing this. shared snip in the above msg

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    Anonymous image you posted is not clear and very small, can you share what is the dax code instead of pasting the image.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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.