Group rows by assignee

[adumith]

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,

[vanessafvg]

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?

[adumith]

You right.

I'm sorry about that.

There you go.

Thank you,

[vanessafvg]

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?

[adumith]

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.