Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

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


1003 2/2/2020
1004 3/3/2020

@HusseinKhalil ,


Let me know if this works out for you


if you need more help make me @

Appreciate your Kudos.

View solution in original post

Super User
Super User

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




Thanks  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 

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


Appreciate your Kudos.



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. 

@HusseinKhalil ,


Let me know if this works out for you


if you need more help make me @

Appreciate your Kudos.

Many thanks @amitchandak, sorry for the late reply 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors