Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys,
I am quite new to PowerBI and have been given a job at work. I have a table from Excel that has Created Tickets details (who created it, date, time etc etc). I want to create a graph where I show the no of tickets created by one helpdesk employee vs the whole team in terms of percentage.
Eg - lets say A created 10 tickets and the total count of tickets created by team is 100. I want a graph or a pie chart (its flexible how I show it) where it can be seen that A created 10% of the total tickets created.
Any help would be really appreciated.
Thanks
Would you be able to share your pbix file or the source data? Make sure to change or hide sensitive information. It is much easier to work with data when given the numbers. Thanks!
Following is the example in green of what I want, lets say Nasim created 3 tickets out of 7 tickets in total. I want to represent this in a report for different scenarios (open, closed, pending etc).
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |