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 months so I had control to start the week on "monday" and to have a better visualization in my graphs. (As image below)


Is there a way to fix this so my Line chart shows the months and weekdays as texts?



Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper 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