View plan & actual on same graph

[HusseinKhalil]

I am stuck with the below, i want to draw both actual and plan on the same line, each for own color sure, actual vlaues should stop at feb-2020, while plan should be continued till march. garph values is the count of dates in each column. i created a calendar and have a relation ship between claendar[date] & Actual same goes for the plan.

Monthly Planned:=CALCULATE(COUNT('Table1'[Plan]),USERELATIONSHIP('Table1'[Plan],'Calendar'[Date]))

Monthly Actual:=CALCULATE(COUNT('Table1'[Actual]),USERELATIONSHIP('Table1'[Actual],'Calendar'[Date]))

below is how the data looks, also I am searching for support rgearding the running total measure. also i need support in this regard

Product	Actual	Plan
1001	1/2/2020	12/31/2019
1002	2/1/2020	1/1/2020
1003		2/2/2020
1004		3/3/2020

[amitchandak]

are they both joined with the calendar. one active and one inactive

Refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[HusseinKhalil]

Thanks  amitchandak for your time, but this is not what i was looking for, topic i was refrred at is amazing, but it is not showing the  values on the same line graph, each ctaegory is viewed separetly, i need to present both column values on the same line. Actual values first then line continues to show the planned for the months that have no actual entries 

[amitchandak]

@HusseinKhalil , can you share better data and expected output and mark me @

Appreciate your Kudos.

[HusseinKhalil]

@amitchandak

https://www.dropbox.com/scl/fi/o7021z3qixsj49sdo4iq7/DataToDropBox.xlsx?dl=0&rlkey=9j749l0aypbmrllgj...

Hello amitchandak

above dropbox link has the data, also a snap inside to how the output should look like, redline is for the actual column, blue line is for the plan. please ignore that dottedblue curve as well as the dashed black line.

thanks for your efforts. 

[amitchandak · Accepted solution]

@HusseinKhalil ,

Let me know if this works out for you

https://www.dropbox.com/s/ofimalh8f9owi2g/cummActual_plan.pbix?dl=0

if you need more help make me @

Appreciate your Kudos.

[HusseinKhalil]

Many thanks @amitchandak, sorry for the late reply