Forecast not showing

[Saisen]

Hi,

I want to forecast, but it doesn't show in the Analytics tab.

Does anyone know the reason?

The data which I wanna forecast and settings are below.

https://imgur.com/a/EXpF2j7

I need your help! Thanks 😄

[amitchandak]

@Saisen , You use R and python, if needed

https://towardsdatascience.com/using-python-in-power-bi-ee95a6b71443

[Saisen]

@amitchandak 

Thank you for your reply.

But I'm not accustomed to R and python, so I wanted to use Forecast because it doesn't require coding.

Could you tell me why I cannot use Forecast?

In addition to the above information, I could use Function when I use the data from web site, so I may mistook the settings.

[amitchandak · Accepted solution]

@Saisen , you can use , refer if this can help

https://powerbi.microsoft.com/pt-br/blog/introducing-new-forecasting-capabilities-in-power-view-for-...

https://databear.com/forecasting-in-power-bi/

[Saisen]

@amitchandak 

Ok, now I understood why I couldn't did it.

The web site you told me says:

Things to keep in mind about forecasting

Forecast is available for line charts only.

• The x-axis value needs to have a date/time format or be a uniformly increasing whole number.
  • It can’t contain text or decimal numbers.
  • Sometimes x-axis values appear to be dates, but they’re actually formatted as text. They won’t work for forecasting.
• The chart has to have only one line. Multiple-line charts don’t work, even if all but one line is filtered out.
• The line chart has to have fewer than 1,000 values. Power View samples data in charts with more than 1,000 values, and forecasting won’t work on sampled data.
• The four most recent values in the time series must increase uniformly, meaning there’s the same length of time between each value.
• The interval between values has to be at least one day.

And I didn't satisfy the requirement. Thank you.