Forecast Model In Linechart

[akshaya2595]

PowerBI Trial File 

I have a dataset that contains the date and the total headcount as of that date.

I have created a line chart and a custom calendar table. This line chart shows the actual headcount by calendar month. 

For the remaining time period, I want to show a forecast for it (based on any dummy calculation for now).. 

The forecast needs to be shown in dashed lines, and also connect to the actuals to make it holistic. 

Can you please tell me the metric calculation for this or how to go about this? Thank you for your time and help!

[v-sshirivolu]

Hi @akshaya2595 ,

I would also take a moment to thank @lbendlin , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-sshirivolu]

Hi @akshaya2595 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[v-sshirivolu]

Hi @akshaya2595 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[lbendlin · Accepted solution]

You can use the built-in Forecast feature.