Hi,
we will have 2 different columns one with the Primary email id and another column with multiple email id's of the same person(the reason for multiple email id's is a contingent employee with one email id and once the contingent employee becomes a permanent employee the email id will be changed) so basically, employees both emails are being tracked in our database.
Now, in the slicer when we search for an employee we need see all the email id's. but when we select the employee email we need to display only the primary email id as per below snapshot.
Can any one help with how can se implemented
| Primary Email id | Multiple Email id's |
| Kaul, Sheetal <sheetal.kaul@hpe.com> | Kaul, Sheetal <sheetal.kaul@hpe.com>,<kaul@hpe.com> |
| Menon, Sheetal <sheetal.menon@hpe.com> | Menon, Sheetal <sheetal.menon@hpe.com> |
| R, Sheetal <sheetal.r@hpe.com> | R, Sheetal <sheetal.r@hpe.com>, <reena.s@hpe.com> |
| Katke, Sheetal <sheetal.katke@hpe.com> | Katke, Sheetal <sheetal.katke@hpe.com>,<talk@hpe.com>,<katke@hpe.com> |
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
