Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cannot build Forecast with WeekNum and Weekdays

I am trying to build a Forecast using the Weeks numbers and Weekdays, so my Line Chart shows me the peaks according to the weekdays, analysing by week (like, week 42, 43...).    The problem i...
Need Help
vicky_'s avatar
vicky_
Super User
2 years ago

Judging by your description, the issue lies in your custom columns - in particular, this article (https://powerbi.microsoft.com/en-au/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/) states that forecasting will NOT work with text types such as weekday. But it will work with whole numbers. So what i can suggest is to use the number representation of your weekday(s) and use the text as either a tooltip, or you will need to write a custom measure for forecasting, which is discussed in this thread: https://community.fabric.microsoft.com/t5/Desktop/Create-a-weekly-forecast-chart/td-p/1353375

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I already did that. The columns "Weekday Nº" and "Week Overall Nº" are the representations of Weekdays and WeekNum in numbers, but still, everytime I put these in my chart, the Forecast button disappears.

    The only thing Power BI recognizes to Forecast is the pre set Date Hierarchy (Year/Quarter/Month/Day).
    I already tried everything I know to have the forecast by weeknum and weekday and had no success at all.