Forum Discussion
Line Chart by date
- 9 years ago
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
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
Just amazing! Thank you very much! Work as requested!