List Visual

[thuetten]

Hi all,

I have a pie-in-the-sky request that I haven't found a way to do and very well may not be possible in Power BI, but I wanted to get any options from others who may know.

I have data set up like below:

Task	Role	Person
1	Manager	Jim
1	Aide	Tim
2	Helper	Kim
2	Owner	Matt
2	Pres	Mike
3	Aide	Mary

I want some sort of visual or something to group it by task, and dispaly the roles and person assigned to it vertically beneath it. So something like

Task 1

Manager - Tim

Aide - Jim

Task 2

Helper - Kim

Owner - Matt

Pres - Mike

Task 3

Aide - Mary

Is there some way I can do this? There's no standard amount of roles per task. I've tried a multi-row card, but I can't get it to group by task. There's a really cool Card Browser in AppSource that groups by task, but it only displays the first role and name and can't display them all. Any ideas, or will I have to use a matrix with expandable rows?

[parry2k · Accepted solution]

@thuetten use matrix visual, add Task and Role on rows and Person on values. 

Drill down to the next level, so you will see each role under each task and name of the person.

I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[thuetten]

I was hoping to do something with a little more separation between tasks, but this does work well enough. Thanks!