Forum Discussion
Forecast Option not visible in Analytics Pane - December 2023 Update.
- 2 years ago
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
- 1 year ago
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.
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?
- SpankMobley1 year agoFrequent Visitor
- Ritaf19831 year ago
Super User
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.