Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I was hoping to do something with a little more separation between tasks, but this does work well enough. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |