Forecasting option - only visible when day is displayed on chart

[annlois]

I understand that the forecasting only works for Line Chart Visual and I do have a line chart with date hierarchy as the X-axis.

I got the forecasting option working when i drilled down to the "day" of the month and when the X-axis type is set to "Continous"

I have the chart but its showing 0, 10, 20, 30 as the x axis values. How i can i enable the forecasting and still be able to show the "months" as the x axis labels and not the exact days with the forecasting option still enable?

 

[Anonymous · Accepted solution]

Hi  @annlois ,

Your x-axis needs to be a date field before it can be implemented, and the current forecast function cannot analyze multiple lines

You can take the date hierarchy month as the x-axis.

This is the related document, you can view this content:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-feature-summary/

https://community.powerbi.com/t5/Community-Blog/Predict-your-milestones-with-forecasting-in-Power-BI...

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.

[amitchandak]

@annlois , I think it can works with exact date and numeric option day