Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Forecast using weekday in text

I am trying to build a Forecast using Weekday but every time I add my Weekday column to the Line Chart, the Forecast option disappears.   In my Calendar table I created columns for weekdays and mon...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

Anonymous forecast only gets calculated if you have a number or date column on the x-axis, since the week is a text column it will not work, if you present the week in a number column, you should be able to use it.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have it in numbers too, the weekdays and the months. The Chart only with numbers stays like this: 

But the Forecast do not appears to me at all

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    The Forecast feature typically requires a continuous date or numeric axis to function correctly.
    The problem here is that the x-axis has two fields, and it can no longer be set as a continuous axis.

    There is a workaround: Please create a new calculated column like:

    Column = 'Table'[Month N]*7+'Table'[Weekday N]-1

    The result returned will be a continuous number:

    You can use it as x-axis.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group