Multiple Line Chart from Table with 2 Dates

I'm trying to create a Line Chart with 2 lines based on the same table. My table is a list of help desk tickets with unique key being the ticket ID #. Each Ticket has a Created Date and a Resolved D...

Need Help

bhanu_gautam

Super User

1 year ago

rickas27

Ensure your table has at least the following columns:

TicketID
CreatedDate
ResolvedDate

Create a Date table to use for the X-axis. This table should cover the range of dates you are interested in (e.g., the past 12 months).

DateTable = CALENDAR(DATE(YEAR(TODAY())-1, MONTH(TODAY()), 1), TODAY())

Relate the CreatedDate column in your tickets table to the Date column in the Date table.
Relate the ResolvedDate column in your tickets table to the Date column in the Date table.

Tickets Created = COUNTROWS(FILTER('Tickets', 'Tickets'[CreatedDate] = 'DateTable'[Date]))
Tickets Resolved = COUNTROWS(FILTER('Tickets', 'Tickets'[ResolvedDate] = 'DateTable'[Date]))

Add a Line Chart visual to your report.
Drag the Date column from the Date table to the X-axis.
Add the Tickets Created measure to the Values field well.
Add the Tickets Resolved measure to the Values field well.

Ensure the X-axis is set to display the past 12 months.
Customize the lines and markers as needed for better visualization.

rickas27

New Member

1 year ago

Does it matter that my CreatedDate and ResolvedDate fields are actually Date + Time?

For example, the value for one of these fields for one of these records would be 2/25/2025 3:00:00 PM

Also you had in your instructions:

Tickets Created = COUNTROWS(FILTER('Tickets', 'Tickets'[CreatedDate] = 'DateTable'[Date]))
Tickets Resolved = COUNTROWS(FILTER('Tickets', 'Tickets'[ResolvedDate] = 'DateTable'[Date]))

What does this mean? Do I have to create a new field?

Forum Discussion

Multiple Line Chart from Table with 2 Dates