Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all! I need help in plotting our ticket's average resolution time to graph. I am grateful for any ideas on how to execute it properly. First of all, I already have the prerequisites such as calendar and time table. What I need guidance for is to properly visualize it, or step-by-step queries needed inside the graph.
This is what I want to achieve:
And here's a glimpse of my current dataset:
The average resolution time column is already in minutes and I have the week columns indicating the particular week number in a month.
Let me know if you have any ideas on how to execute it. It will mean so much. Thank you!
Solved! Go to Solution.
Hi @Anonymous ,
Is that your excepted result?
For more details, please check the pbix as attached.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 44 | |
| 41 | |
| 36 | |
| 21 |
| User | Count |
|---|---|
| 176 | |
| 120 | |
| 106 | |
| 77 | |
| 52 |