Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I've been Googling and reading to try and find a solution however struggling to piece examples I have found together to match my scenario. I'm hoping you brilliant people can offer advice.
I have a table containing closed support tickets. I have added a table visual to a page and it has been filtered on tickets closed the previous week using a slicer. From this data, I want to select individuals/ticket assignees (can be done via a slicer or any other suggestions) who closed a ticket last week and have Power BI present a random ticket. I need the ability to select the individual and multiple ones, not all individuals would get selected.
How might I go about this?
My table includes columns such as reference number, status, customer, raised user, start date, end date, title, support group, assignee
Hi @Anonymous ,
I want to select individuals/ticket assignees (can be done via a slicer or any other suggestions) who closed a ticket last week and have Power BI present a random ticket. I need the ability to select the individual and multiple ones, not all individuals would get selected.
I still have a little confused about your scenario.
If it is convenient, could you share your data sample and your desired output so that I could understand your scenario better.
In addition, what do you mean of "have Power BI present a random ticket"?
Best Regards,
Cherry
Hi @v-piga-msft
You can download sample data that resembles the type of information I'm working with here https://1drv.ms/f/s!AvDRYI7zzwDhoE0qyYcG3GHxtX7x
In my sample data, I have 10 Assignees and each of them has closed/resolved 10 tickets each last week.
I want the table visualisation on the Power BI dashboard to select at random one ticket for each of the selected Assignees in the slicer. In the saved Power BI file, I have selected two Assignees, I only want the table to show me one random ticket for each.
If there's a better way to do this other than a table, I'm happy for other suggestions too.
The idea is to have a random ticket selection to then conduct an internal audit/review.
Any help would be enormously appreciated as I'm not sure how I can go about this.
Thanks,
Amy
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |