Forum Discussion
Continued ContributorForcast option disappears when I drilldown
I was using a hierarchy in a date table that was built from the date field. However this only seems to work with powerbi generated date hierarchies. Once I turned off the date table and powerbi autogenerated hierarchies for all the date fields I was able to use forcast with one of them.
Hi bsheffer ,
Ensure there is no fields in Legend area and you are using Date column in Axis area.
You will only get forecasting option when on x-axis you've used column that is of type datetime / number, it won't work with other data type columns. Also it requires more than six data points on x-axis to forecast.
This is related content, hope to help you:
https://community.powerbi.com/t5/Desktop/Forecasting-tab-not-available/m-p/75281
https://community.powerbi.com/t5/Desktop/Forecasting-feature-in-analytics-pane-is-missing/m-p/707613
https://community.powerbi.com/t5/Desktop/Forecasting-feature-is-missing/m-p/157266
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.