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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JD09
Advocate I
Advocate I

Forecast Option not visible in Analytics Pane - December 2023 Update.

Where Can I Find The Forecast Option in Analytics Pane In Power BI Desktop December 2023 Update?
Thank You!!

1 ACCEPTED SOLUTION

Hi @JD09 

Make sure that the x-axis is continuous and not categorical.

Ritaf1983_1-1705047069019.png

 

I also attached the pbix

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

10 REPLIES 10
Ritaf1983
Super User
Super User

Hi @JD09 
At the regular place if you use a standard view 

Ritaf1983_0-1705044905943.png

and under "format" if you use an on object interraction:

Ritaf1983_1-1705045141597.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

@Ritaf1983 The forecasting option is not listed in either of your screenshots. Average, median, and other reference lines are descriptive of the data that already exists. There are numerous posts online about a forecasting option being at the bottom of the analytics pane, but MS appears to have removed it?

SpankMobley_0-1734102217463.png

 

Hi @SpankMobley 

The forecasting feature in Power BI does exist, but it’s important to note that it’s not available for every chart type or data type.

Forecasting is only available for line charts under the following conditions:

The X-axis must contain a continuous field, such as dates or numbers.
The chart must include a single line; this feature is not supported for charts with multiple data series.
There must be sufficient relevant data for the Power BI forecasting engine to perform the necessary calculations.
This is not a bug but rather a deliberate limitation of the feature, depending on the type of data and visualization.

Ritaf1983_0-1734152140516.png

PBIX is attached 

more information about the feature here:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#apply-forecasting

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thanks for the reposnse @Ritaf1983 
Have checked the Analytics Pane, Could not find the Option..

Hi @JD09 

Make sure that the x-axis is continuous and not categorical.

Ritaf1983_1-1705047069019.png

 

I also attached the pbix

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thanks @Ritaf1983 ,
It worked!!

 

Happy to help 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Idrissshatila
Super User
Super User

Hello @JD09 ,

 

it's here, just know that it only shows for line charts

Idrissshatila_0-1705044847954.png

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thanks for the Response @Idrissshatila 
Using a Line Chart..
But, I could not find the Option for the Forercast in Analytics Pane..
Please find the reference Screenshot

JD09_0-1705046390198.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors