Forum Discussion

akshaya2595's avatar
akshaya2595
New Member
11 months ago
Solved

Forecast Model In Linechart

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!

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        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.