Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create a weekly forecast chart

I want to create a weekly forecast chart on sales for the next 2 weeks. I have a daily date field(this contains multiple records for each date) and sales. How do i plot this such that it displays sta...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , if you want power BI line forecast. You can have the week start date

 

Week Start Date = [Date] - Weekday([Date]) -1 //Sunday

Week Start Date = [Date] - Weekday([Date],2) -1 //Monday 

 

Plot this in a line visual and forecast for 2 periods use week start date as the axis.

https://powerbi.microsoft.com/pt-br/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/

 

Or You can use R/Python integration

 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts
https://en.blog.businessdecision.com/how-to-use-the-python-integrator-in-powerbi/
https://towardsdatascience.com/using-python-in-power-bi-ee95a6b71443
https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/

https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/
https://www.ahaapps.com/microsoft-power-bi-service-with-python-visualizations/

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak 

     

    Thanks for your response. Your solution got me close to what I'm looking for. The only thing about the visualization is that it failed to show the actual start of week on the x-axis when i made the forecast instead it shows the month year. Is there a way i can solve this? Please see below. Thanks.