Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello guys,
The following report is a pivot table that I have developed in Excel, I wonder if it's possible to do something similar in Power BI.
As you can see in the pivot table, the goal is to group the rows by agent and display them in descending order, taking as a criterion the ticket age column.
I have used the Power BI table visualization but I haven't been able to do the grouping.
Sample Data:
Ticket ID | Created - Timestamp | Priority | Assignee | Requester | Subject | Category | Ticket Age |
5953 | 2022-01-03T08:21:18 | Medium | Tommy Nguyen | Michael Chen | justo sit amet sapien dignissim vestibulum vestibulum ante ipsum primis in | Hardware Misc. | 286 |
13582 | 2022-01-03T08:21:18 | Normal | Tommy Nguyen | Michael Chen | dolor vel est donec odio justo sollicitudin ut suscipit a feugiat et eros vestibulum ac est lacinia nisi venenatis tristique | Drop Box/On line storage | 189 |
18866 | 2022-01-03T08:21:18 | Normal | Emily Davis | Michael Chen | platea dictumst aliquam augue quam sollicitudin vitae consectetuer eget rutrum | Hardware Misc. | 713 |
92965 | 2022-01-03T08:21:18 | Normal | Emily Davis | Amanda Wilson | mi nulla ac enim in tempor turpis nec euismod scelerisque quam turpis adipiscing lorem vitae mattis | Drop Box/On line storage | 787 |
69626 | 2022-01-03T08:21:18 | Urgent | Olivia Patel | Karen Rodrigue | id mauris vulputate elementum nullam varius nulla facilisi cras non velit nec nisi vulputate nonummy maecenas tincidunt lacus at velit | Drop Box/On line storage | 451 |
37209 | 2022-01-03T08:21:18 | High | Jane Smith | Sarah Johnson | a feugiat et eros vestibulum ac est lacinia nisi venenatis tristique fusce congue diam id ornare | Drop Box/On line storage | 479 |
90940 | 2022-01-03T08:21:18 | Normal | Jane Smith | Sarah Johnson | dapibus duis at velit eu est congue elementum in hac | Hardware Misc. | 23 |
71463 | 2022-01-03T08:21:18 | High | Sarah Wilson | John Smith | metus arcu adipiscing molestie hendrerit at vulputate vitae nisl aenean lectus | Remote Access/Desktop | 131 |
13154 | 2022-01-03T08:21:18 | Medium | Olivia Patel | David Lee | condimentum curabitur in libero ut massa volutpat convallis morbi odio odio elementum eu interdum eu tincidunt in | Hardware Misc. | 486 |
8629 | 2022-01-03T08:21:18 | Urgent | Tommy Nguyen | Daniel Kim | iaculis justo in hac habitasse platea dictumst etiam faucibus cursus urna ut tellus nulla ut erat id mauris vulputate elementum | Drop Box/On line storage | 119 |
17085 | 2022-01-03T08:21:18 | Normal | Olivia Patel | Daniel Kim | eros elementum pellentesque quisque porta volutpat erat quisque erat eros viverra eget congue eget semper rutrum | Hardware Misc. | 841 |
30006 | 2022-01-03T08:21:18 | High | Mike Johnson | John Smith | sapien non mi integer ac neque duis bibendum morbi non quam nec dui luctus | Remote Access/Desktop | 714 |
27456 | 2022-01-03T08:21:18 | Urgent | Sarah Wilson | Daniel Kim | in consequat ut nulla sed accumsan felis ut at dolor quis odio consequat | Remote Access/Desktop | 202 |
60461 | 2022-01-03T08:21:18 | Low | John Doe | Kevin Patel | phasellus id sapien in sapien iaculis congue vivamus metus arcu adipiscing molestie hendrerit at vulputate vitae nisl aenean lectus | Hardware Misc. | 49 |
96707 | 2022-01-03T08:21:18 | High | Emily Davis | John Smith | vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae mauris | Drop Box/On line storage | 450 |
44307 | 2022-01-03T08:21:18 | Low | Emily Davis | Rachel Garcia | convallis nulla neque libero convallis eget eleifend luctus ultricies eu nibh quisque id justo sit amet sapien dignissim vestibulum | Drop Box/On line storage | 856 |
81237 | 2022-01-03T08:21:18 | Medium | Jane Smith | David Lee | ultrices mattis odio donec vitae nisi nam ultrices libero non mattis pulvinar nulla pede ullamcorper | Drop Box/On line storage | 148 |
70827 | 2022-01-03T08:21:18 | Urgent | Mike Johnson | Rachel Garcia | congue risus semper porta volutpat quam pede lobortis ligula sit amet eleifend pede libero quis | Drop Box/On line storage | 529 |
5984 | 2022-01-03T08:21:18 | Urgent | Olivia Patel | Amanda Wilson | molestie nibh in lectus pellentesque at nulla suspendisse potenti cras in purus eu magna vulputate | Remote Access/Desktop | 159 |
1640 | 2022-01-03T08:21:18 | Low | David Lee | David Lee | justo morbi ut odio cras mi pede malesuada in imperdiet et commodo vulputate justo | Drop Box/On line storage | 904 |
75387 | 2022-01-03T08:21:18 | Low | David Lee | Karen Rodrigue | eget eros elementum pellentesque quisque porta volutpat erat quisque erat eros viverra eget congue eget | Remote Access/Desktop | 890 |
Any idea?
Thanks,
if you could provide some sample data even if not your real data, sites like mockaroo help to create sample data, the it would be quite easy to show you if you can give an extract in text format?
Proud to be a Super User!
You right.
I'm sorry about that.
There you go.
Thank you,
actually it is a bit tricky to do it exactly as it is in excel and you are correct, there isn't a one for one experience. so you want to replicate the report in power bi, what is the value add power bi gives you. If you really intent on using the exact matrix experience you can customize in excel, what do you want power bi to do for you? I think if we can break that down that would be useful. You can do power query into excel.
Otherwise you might need to try a new one of expressing this data in power bi.
examples in matrix / tables but also there are many different ways when you can do data visualsation.
but this isn't the only way, what is the message you are trying to communicate?
Proud to be a Super User!
Hello!
There is really no hidden message.
I'm sorry if it came across that way.
What I'm trying to do is create a SIMILAR report, which means having a table with the tickets records grouped (if possible) by agent and sorted by the Ticket Age field in descending order.
Thank you for taking the time to help me with this.
I greatly appreciate it.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |