Forum Discussion
LF forecast line?
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
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 :(
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
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?
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
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