Forum Discussion

Doliveira's avatar
Doliveira
Frequent Visitor
9 years ago
Solved

Line Chart by date

Hi everyone,   I'm trying to create a line chart with two lines, using the columns "Reported Date" and "Closed Date". Those columns have the date format "dd/mm/yyyy". The result of this chart shoul...
  • vanessafvg's avatar
    9 years ago

    Doliveira

     

    what you need to is create a date table

     

    then you need to create 2 relationships to your date table

    one from reported date to date

    another from closed date to date

    you will see the second one becomes a --- line that will be the inactive relationship

     

    then you need to place your date from you date table on the visual

     

    your first measure will be 

    reported count = calculate(countrows(tablename))

    closed count = calculate(countrows(tablename), userelationship(table[closeddate], datetable[date])

     

    then you can plot both