Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a date hierarchy
year
quarterno
month mmm
date
value is a sales total measure
I want to drilldown and show a forcast on quarters
at the year level I can create the forcast, but as soon as I drilldown to the quarterno it disappears and I don't have the option on my analytics menu. How can I fix this?
Solved! Go to Solution.
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |