Line Chart for different Data points

Power BI
1

Hi,
I have a request from my client,
I have Demand Units
I have Forecasted Units

Demand Units are those which are realized
Forecasting Units are the forecasting for 12 months.

Mention below is the image which was made in Excel
Green Line Shows the Forecasting for the Next Year for 12 Months
Blue Line Shows the Forecasting for the Previous Year for 12 Months

Current Year is a Combo of both (Realized i.e. Demand Units and Forecast for the next months)
Current Year Demand Units i.e. till Month realized Units color is Light Blue
Current Year Forecast Unit i.e. Rest of the Months Forecast month Color is Orange.

I need the Line Chart same in Power BI also.

Hope I was able to explain my problem well
Research_v2_InquiryPurpose.pbix (48.7 MB)

Resaerch
Resaerch948×389 52 KB

3

Please advise the measure or column of data you are trying to get this chart created with. I see ‘forecast units’ and ‘demand units’ but there are many other fields too. Please clarify.
Thanks.

4

Thank you for the response, I am trying to get this chart created with the support of the Forecast and Demand Unit Columns.

Please also check the detail that I have mentioned in my Problem.

5

@lsquintana17 The Demand Unit Column is “SO History Req Date” and Forecast is the Forecast column from the YoY Pre_Period_Data.
Current State

Research
Research1162×259 15.4 KB

and Need it in the mention below state format

Resaerch
Resaerch948×389 52 KB

Hope it helps and clarifies.

Thank you,

6

did you check on youtube? I’m not sure if it can be done in power bi

7

Hi @mohammedkhan11, we’ve noticed that no response has been received from you since July 3. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

8

Hi @mohammedkhan11, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.