Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
10 months ago
Solved

Forecast in Line Chart

I do not see any forecast option available in Power BI while creating line chart

 

 

Need Help
  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi powerbiexpert22,

     

     

    1. Use a Line chart (not Area/Combo/custom).
    2. Put a Date (or numeric) field on the X-axis and set the X-axis Type = Continuous.
    3. Put one measure in Values (no Legend/multiple series).
    4. Click the visual, open the Analytics pane, expand Forecast, and click Add. See Microsoft’s guide: Use the Analytics pane to apply forecasting.

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

2 Replies

  • tayloramy's avatar
    tayloramy
    Super User
    10 months ago

    Hi powerbiexpert22,

     

     

    1. Use a Line chart (not Area/Combo/custom).
    2. Put a Date (or numeric) field on the X-axis and set the X-axis Type = Continuous.
    3. Put one measure in Values (no Legend/multiple series).
    4. Click the visual, open the Analytics pane, expand Forecast, and click Add. See Microsoft’s guide: Use the Analytics pane to apply forecasting.

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

  • v-achippa's avatar
    v-achippa
    Community Support
    9 months ago

    Hi powerbiexpert22,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you tayloramy for the prompt response.

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa