Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
LucasCamargo
Helper I
Helper I

How to build Forecast with Week number 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 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)

LucasCamargo_0-1700662211764.png

 

Is there a way to fix it? Or a way to introduce in my Date Hierarchy the Week numbers and Weekdays?

1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

Hi @LucasCamargo ,

 

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

vtangjiemsft_0-1700812305274.png

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.

vtangjiemsft_1-1700812591298.pngvtangjiemsft_2-1700812605514.png

 

 

 

 

View solution in original post

1 REPLY 1
v-tangjie-msft
Community Support
Community Support

Hi @LucasCamargo ,

 

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

vtangjiemsft_0-1700812305274.png

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.

vtangjiemsft_1-1700812591298.pngvtangjiemsft_2-1700812605514.png

 

 

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Users online (521)