Forum Discussion

noamshn's avatar
noamshn
Frequent Visitor
3 years ago

2 lines in 1 chart

Hello everyone,

I have a table with creation date and completion date. I want to make a line chart that will show 2 graphs, the count of creation dates in 1 graph (by month) and the count of completion dates in the second graph (by month).
In the table i created 4 new columns, month and year columns for the creation and completion dates.

After this i created a relationtiop between a calendar table and the month created column. because i cant create another relationtiop when i create the chart the creation line is good but the completion line is not the real data.

what am i doing wrong and how can i fix it?

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    noamshn you need to create using completion date as well, but it will be inactive which is fine and then you can add measure to make it active:

     

    Completion Count = 
CALCULATE ( COUNTROWS ( Table ), USERELATIONSHIP ( Table[Completion Date], DateTable[Date] ) )
  • noamshn's avatar
    noamshn
    Frequent Visitor
    3 years ago

    parry2k thank you.
    so now i can see the right numbers when i'm not filtering by the year. how should i add the year of each one (completion and creation) in the filter? i created a completion year and creation year column and when i filter with both of them it not showing the real values.