Forum Discussion
Line Chart - Project Created vs Project Completed
Hi h11
Assuming you have a calendar table,
you need to create two relationships between it and the tasks table:An active relationship with the task creation date.
An inactive relationship with the task completion date.
As shown in the attached imageThen you can create 2 measures :
Created tasks = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Task Status]="Created"))Completed tasks = CALCULATE(COUNTROWS('Table'),USERELATIONSHIP('Calendar'[Date],'Table'[Task Completed Date]),'Table'[Task Status]="Completed")Put the measures + month column from calendar table on the graph :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi h11
Assuming you have a calendar table,
you need to create two relationships between it and the tasks table:
An active relationship with the task creation date.
An inactive relationship with the task completion date.
As shown in the attached image
Then you can create 2 measures :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Ritaf1983 : Thank you so much for attaching the pbi file. This saved my time. I appreciate it!
Could you provide a measure that excludes the task status? I want to create a line graph using only the months and the created and completed dates, without including the task status into the measure.
Thank you in advance!
Hi h11,
Perhaps you can also take a look the following link about expand the date range and create new table based on these records if this suitable for your requirement.
Solved: Spread revenue across period based on start and en... - Microsoft Fabric Community
Regards,Xiaoxin Sheng
Hi h11
You can modify the formulas to :Created tasks = COUNTROWS('Table')Completed tasks = CALCULATE(COUNTROWS('Table'),USERELATIONSHIP('Calendar'[Date],'Table'[Task Completed Date]),'Table'[Task Completed Date]<>BLANK())The updated PBIX is attachedIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
