Line Chart Assistance

[bixby]

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.

[gpiero]

@bixby 

Hi, 

could you share some sample data or an expected result you are looking for?

Regards

[bixby]

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

[V-lianl-msft · Accepted solution]

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_)

Sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.