one item belongs in two groups

[barb8354]

Hi all,

I'm new to PowerBI.  I have a need to put one item into two groups.  I work for a University in the Athletics department.  I'm am creating a report that shows student-athletes by sport; however, I have a student-athlete that is in two sports.  When I group by sport I need him to show up in both.  For example, our one athlete is on the football team and also track & field team.  When I bring up football he should be on the roster, and when I bring up track and field he should be on that roster.  I have the grouping working, but how do I put him in two groups?

[BKirsch12 · Accepted solution]

Typically for situations like this, you need one record to state the person is in one sport, as well as another record stating they are in another sport. This example shows how you could list the applicable sports a person plays:

As you can see I do two sports: Baseball and Swimming. Now when you group by, I would show up under both sports.

[barb8354]

I figured it out.  Each sport needs its own report.  This uncomplicates many things, including permissions.

[BKirsch12]

Glad you came to a solution. If my solution would have fixed your original request, please mark it as an accepted solution. This will allow the next person with a similar issue to quickly find resolution.