Forecasting report for sales month Power BI

[Anonymous]

Hi Expert,

I have one chart to create forcasting for sales month. I am trying to create but still could not get the actual idea.

This is my Sample data souce:

Model	Zone	Date	Orders FTD	Retails FTD
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	10	3
Intel	North 1	########	1	3
Intel	North 1	########	1	3
Intel	North 1	########	2	3
Intel	North 1	########	2	3
Intel	North 1	########	2	3
Intel	North 1	########	2	3

Sample Output:

Thank in Advance.

Regards,

Irshad Ahmad

[amitchandak]

@Anonymous , I am not able see sample output.

But refer

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

https://www.youtube.com/watch?v=XIlPkyyztho

[Anonymous]

Thank you @amitchandak for your quick responce.

Sample Output:

Regards,

Irshad Ahmad

[v-juanli-msft]

Hi @Anonymous 

Which column from your table should be added into x-axis of the line chart?

Is the month column added into a slicer?

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft Thank you for you time.

Month column will be x-axis in my report.

Regards,

Irshad Ahmad

[v-juanli-msft]

Hi @Anonymous 

You could add forecast line in a line chart as below:

https://www.youtube.com/watch?v=fLqvaWJtwhQ

But this line chart doesn't support add another column as a second line.

Best Regards

Maggie

[Anonymous]

Thank you @Maggie for your idea.

As per the requirement,I need to display multiple line in a chart.

Regards,

Irshad Ahmad