Forum Discussion
Solved
Multiple values in cell - use as filter
Hello, I am trying to develop a dashboard of the registration history of a training program, for which all data has been historically kept in a spreadsheet. There is a single entry for each student r...
Hi krdavies
Keep that split table you made where you broke out each student-mentor combo into separate rows. and follow rthses steps:
Change how the relationship works:
- Open Model view
- Click the line between "Mentor relationships" and "Registrant History"
- Set Cross filter direction to Both
Add your slicer:
- Drop the MENTOR field into a slicer visual
- Pick a mentor and it'll pull up everyone they work with
Basically the filter needs to work both ways, right now it only goes one direction, so selecting a mentor doesn't push back to your main table.
If that doesn't fix it, try changing the relationship type to Many-to-Many, sometimes Power BI gets picky about cardinality when you've got duplicate IDs floating around.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
Thank you, this worked perfectly!
Glad it worked, I am happy for you