Forum Discussion
Line Chart Assistance
Hi bixby ,
Maybe I understand what you mean,you need to create an unrelated calendar table as an x-axis or slicer.
Then create 4 measures like this:
Measure = var count_ = CALCULATE(COUNT('Table (3)'[ticket_id]),FILTER('Table (3)','Table (3)'[created_date].[Date]=MAX('Table'[Date]))) return IF(ISBLANK(count_),0,count_)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Desired outcome:
Apply ONE date slicer to multiple date values in a line chart (chart shows number of tickets by date - lines represent "created", "assigned", "resolved", "unassigned"):
Example line chart
Sample Data:
| ticket_id | created_date | assigned_date | resolved_date | unassigned_date |
| 1 | 7/29/2020 8:59:34PM | 7/29/2020 9:19:34PM | 7/30/2020 12:59:34PM | |
| 2 | 7/29/2020 9:59:34PM | 7/29/2020 | ||
| 3 | 7/29/2020 10:59:34PM | 7/29/2020 9:25:34PM | 8/3/2020 6:59:34PM |
Hi bixby ,
Maybe I understand what you mean,you need to create an unrelated calendar table as an x-axis or slicer.
Then create 4 measures like this:
Measure =
var count_ = CALCULATE(COUNT('Table (3)'[ticket_id]),FILTER('Table (3)','Table (3)'[created_date].[Date]=MAX('Table'[Date])))
return IF(ISBLANK(count_),0,count_)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.