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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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