Forum Discussion
View plan & actual on same graph
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 |
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.
6 Replies
are they both joined with the calendar. one active and one inactive
Refer
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
