Forum Discussion
combo column and line chart
I need help to display various departments' ticket volume and average resolution time by month and be able to display the trend clearly for each department.
My data set looks something like this:
| Ticket ID | Date Opened | Date Resolved | Department |
| 001 | December 12, 2022 | January 14, 2023 | A |
| 002 | January 2, 2023 | January 8, 2023 | B |
| 003 | February 1, 2023 | February 10, 2023 | A |
| 004 | January 14, 2023 | February 2, 2023 | C |
| 005 | February 1, 2023 | February 25, 2023 | B |
| 006 | February 14, 2023 | February 22, 2023 | C |
I am able to display the volume vs average resolution time by department using a line and column chart. However, I need
to display the average resolution times as multiple individual lines (by department).
I have only been able to do the following:
1. Average Total Resolution as a single y axis
2. Separate measures (average resolution time) for each department as multiple y axis, but they're appearing as disconnected dots:
What I need is for it to look like this:
Any help would be greatly appreciated. Thank you.
1 Reply
- amitchandak
Super User
TedLasso , seem like very similar to what i have done in Employee tenure, check if video and file can help
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
