Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Where Can I Find The Forecast Option in Analytics Pane In Power BI Desktop December 2023 Update?
Thank You!!
Solved! Go to Solution.
Hi @JD09
Make sure that the x-axis is continuous and not categorical.
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
Hi @JD09
At the regular place if you use a standard view
and under "format" if you use an on object interraction:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
@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?
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.
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.
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.
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
Happy to help 🙂
Hello @JD09 ,
it's here, just know that it only shows for line charts
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
79 | |
78 | |
57 | |
37 | |
35 |
User | Count |
---|---|
99 | |
56 | |
56 | |
46 | |
40 |