How to build Forecast with Week number and Weekdays

[LucasCamargo]

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 is: every time I tried to add the weekdays or week nº fields, even been a numbers fields (not text), the Forecast option disappears and i'm not able to use it properly.

For my chart i'm not using the normal Date Hierarchy power BI gives me automatically. Instead, 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 it? Or a way to introduce in my Date Hierarchy the Week numbers and Weekdays?

[Anonymous · Accepted solution]

Hi @LucasCamargo ,

Referring to the document, there are some limitations to the prediction function.

You can create a column.

weekday_num = WEEKDAY('DateTable'[Date],2) 

Place the [weekday_num] and [WeekNum] fields on the x-axis of the line graph to turn on the forecasting function of the Analysis pane. Make sure your line chart is not drilled down for you to see the forecast function.