Forum Discussion

Olia's avatar
Olia
Icon for Advocate II rankAdvocate II
8 years ago
Solved

LF forecast line?

  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 ...
Need Help
  • ValentinBIA's avatar
    ValentinBIA
    8 years ago

    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

ValentinBIA's avatar
ValentinBIA
Icon for Resolver I rankResolver I
8 years ago

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's avatar
    Olia
    Icon for Advocate II rankAdvocate II
    8 years ago

    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's avatar
      ValentinBIA
      Icon for Resolver I rankResolver I
      8 years ago

      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's avatar
        Olia
        Icon for Advocate II rankAdvocate II
        8 years ago

        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?