Forum Discussion
List Visual
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?
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!
2 Replies
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!
I was hoping to do something with a little more separation between tasks, but this does work well enough. Thanks!
