Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I'm pretty stucked with something what I want to highlight in a report about how employees handling tickets.
I want to show statistics for each employees (filtering individually) using card visual with information what is percentage of sev1 and sev2 he has resolved.
We have 4 ticket severity, from 1 to 4 (lowest). Ratio is:
So, I dont want to show whole table with unnecessarily data like this:
I dont want show the count of sev1+sev2 (irrelevant) - it must be info about percentage of sev1 and sev2 (the summ or separatelly) between all ticket resolved by that employee.
Thank you in advance
Petra
Solved! Go to Solution.
Huh, I make it possible!
I don't know why was so hard to write this measure!?
Ok, I'm begginer, recently started to learn 🙂 Thanks anyway!
Can you just filter out Severity 2 and 3 from your visualization?
Unfortunatelly, the result is this:
His statistic is:
So I need only one information: that he has resolved 95/416*100 sev1 tickets of all his tickets.
Very simple but...impossible for me.
p
Huh, I make it possible!
I don't know why was so hard to write this measure!?
Ok, I'm begginer, recently started to learn 🙂 Thanks anyway!
OK, just collapse your unwanted columns so that they disappear? Can you post some sample data and a screen shot or explanation of the fields filled into your visual?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |