LF forecast line?

[Olia]

So I was watching a tutorial where they have shown us just how cool the Forecast feature is for Line chart.... and now the cruel reality appears to catch up with me. Can someone please tell me if that feature is still available, and if so, where I can find it?

[ValentinBIA]

Hi @Olia,

The feature is still available, I use it very frequently.

Make sure you have the latest update of Power Bi Desktop !

And if so, the option for the forecast line only appears if:

- You are using a line chart

- There are values in your Values field

- There are Time Values in your Axis field (such as month, days...)

Hope that helps

Best,

Valentin

Did I answer your question? Mark my post as a solution!

[Olia]

Hi @ValentinBIA

I don't see it. I just re-downloaded PowerBI Desktop. I do have Date in Axis field and Amount in Values field. I am using the Line Chart. but the option is not there 😞

[ValentinBIA · Accepted solution]

I think the date value cannot be in months (except if it month number).

I guess it has to be in weeks, days or month number. Therefore a number and not a text.

EDIT: Yep, just checked, the date value has to be a number for sure, so go for month number instead of month name

[Olia]

@ValentinBIA

I think there's more to that. the forecast line appears when I choose "continues" x-axis option. but then it shows months as 2-6-8, do you know how to make it show months from 1 to 7 without switching to "categorical" x-axis? or how do you make your graphs show all the month numbers?

[ValentinBIA]

Hi @Olia,

I'm sure about it, but maybe you can find the solution there:

https://community.powerbi.com/t5/Desktop/Show-all-Dates-on-continuous-X-axis/td-p/176837

Best,

Valentin

[Olia]

Thank you for looking at it @ValentinBIA  🙂

I managed to get the Forecast line thanks to you, for the rest I guess that I should make a new topic