Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
HI
I am strugling with a very common situation and was not able to found answer in the forum.
I have a table that represents a list of tickets opened in a service center. For each row we have the tichet reference, the opened date and the closed date if the ticket is solved.
Which Power bi model I need to report a graph with opened, closed and still opened tickets ( different between opened and closed) per month ?
Thanks for your help
regards
here is a minimal simple sheet of inial data
SR | Opened date | Closed Date |
T1 | 1-Jan-16 | |
T2 | 1-Jan-16 | 1-Feb-16 |
T3 | 2-Feb-16 | 4-Feb-16 |
T4 | 3-Mar-16 | |
T5 | 4-Apr-16 | |
T6 | 4-Apr-16 | |
T7 | 4-Apr-16 | 01-mai-2016 |
T8 | 1-May-16 | 8-May-16 |
Let me know if you need any other clarification.
Regards.
Solved! Go to Solution.
Hi @Cyberfred95
Check the file at here:
https://drive.google.com/file/d/0B26iWnIZh6PSaWdBTXVKcVZIZlU/view?usp=sharing
I have created a conditional column for finding still opened and closed tickets and for created tickets, I created measure
Created:=COUNTA(data[SR])
To visualiza monthly data, I have created a data table and imported into powerbi, Created a relationship with opened date column.
Need Clarification on this
"Which Power bi model I need to report a graph"
HI
Sorry for My English. I just wanted to says : How do I need to do with Power Bi desktop to report a chart where I will have on the same chart the number of tickets created, solved and still opened per month.
Thanks for your help
regards
Hi @Cyberfred95
Check the file at here:
https://drive.google.com/file/d/0B26iWnIZh6PSaWdBTXVKcVZIZlU/view?usp=sharing
I have created a conditional column for finding still opened and closed tickets and for created tickets, I created measure
Created:=COUNTA(data[SR])
To visualiza monthly data, I have created a data table and imported into powerbi, Created a relationship with opened date column.
Hi Bhavesh,
For the same sample data, is there a way to get this output. I am looking for Total Active tickets during that month.
Total Active | Opened | Closed | |
Jan | 2 | 2 | 0 |
Feb | 3 | 1 | 2 |
Mar | 2 | 1 | 0 |
Apr | 5 | 3 | 0 |
May | 6 | 1 | 2 |
Sample Data:
SR | Opened date | Closed Date |
T1 | 1-Jan-16 | |
T2 | 1-Jan-16 | 1-Feb-16 |
T3 | 2-Feb-16 | 4-Feb-16 |
T4 | 3-Mar-16 | |
T5 | 4-Apr-16 | |
T6 | 4-Apr-16 | |
T7 | 4-Apr-16 | 1-May-16 |
T8 | 1-May-16 | 8-May-16 |
Thanks in Advance,
Kiran.
This looks perfect.
Thanks very much for this
regards
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |