Forum Discussion
Line Chart Assistance
Hi all,
I have a table TICKETS that has date columns [ created ] , [ assigned ] , [ resolved ]
I want to display a line chart of all the tickets with those three separate lines as they all have separate dates and see the count of tickets relative to the values in those columns.
I created a measure of all the tickets (COUNTROWS[ Tickets ]) and tried applying that to the VALUES and the columns to the AXIS and Secondary Axis - yet the numbers displayed on the line chart are off. Only the Created number is correct.
I'm having a hard time wrapping my head around this.
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.
3 Replies
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.
